Hi!

This is my problem:

In my VB app I'm using dbGrid, which uses data control (Dat)as datasource.
Dat.recordsource = "SELECT ID_buy, ID_sell, ID_produce FROM tbl1 WHERE IDNum = " & IDNumber <-- given from user

Now, this works fine, the problem is just, that values in this table are just numbers (sort of ID_numbers) of activities, that are stored in others tables, e.i.

tbl2
ID_buy Activity [text]


tbl3
ID_sell Activity [text]

tbl4
ID_produce Activity [text]

Now, what I'm asking is How to create query, that will return activities (from each tbl2, tbl3, tbl4) instead of of ID numbers of that activities.

Thanks for help!