1 (edited by v_pozidis 2017-10-03 09:52:59)

Topic: Table

Hi sir,
I have two tables.
First Table has record DATE and Work
Second Table has records Date and Meeting.

How can I create a TableGrid  that will show the Dates of Work And Meeting in the same table, sorted by the Date.
What I wanna do is a reminder. It would be nice to get an example.
Thank you.

Re: Table

Hello.


If between these tables there is no any relationship, you should use SQL query:


SELECT date, work FROM tabone 
UNION ALL
SELECT date, meeting FROM tabtwo
ORDER BY date

Example of reminder
http://myvisualdatabase.com/forum/misc. … download=1

Dmitry.

3 (edited by v_pozidis 2017-10-04 12:18:29)

Re: Table

In a software which has many tables can I have the reminder with many records, or is it a problem for the database?

Thank you.

DriveSoft wrote:

Hello.


If between these tables there is no any relationship, you should use SQL query:


SELECT date, work FROM tabone 
UNION ALL
SELECT date, meeting FROM tabtwo
ORDER BY date

Example of reminder
http://myvisualdatabase.com/forum/misc. … download=1