Hi all
OK, I know the data structure I am about to describe probably breaks all the rules of logic and normality, but this is a data retrieval operation only.
The situation is that I will have five queries, each possibly returning info from different tables.
Within each table there is an item number field. This corresponds to an item number ballooned on engineering drawing.
For example, the query on table 1 may return material details for items 1, 2 and 5, with the query on table 2 returning details for items 3 and 4.
I am guessing here, but do I need to query those five queries to be able to sort the results into item number order???
Also, at present the fields that contain those item numbers have labels specific to each table. So how do I query the five table queries to sort on the different item number fields and order by the result?
Hope this is all clear.
Thanks
Phil