Hi to all.
I have an application in which the user selects an 'index' record from a table in order to gather information from just one of several 'data' tables (depending on the information required) and then print a report.
The user wants to print his details along with each report, almost like a letterhead.
I have created a 'user' table containing his pertinent information. Just one record.
How do I include this one record in the current queries? These queries gather their information from the 'index' table and the 'data' table, using joins, and then print a report containing data from both tables.
Regards - :banghead:
I have an application in which the user selects an 'index' record from a table in order to gather information from just one of several 'data' tables (depending on the information required) and then print a report.
The user wants to print his details along with each report, almost like a letterhead.
I have created a 'user' table containing his pertinent information. Just one record.
How do I include this one record in the current queries? These queries gather their information from the 'index' table and the 'data' table, using joins, and then print a report containing data from both tables.
Regards - :banghead:
Last edited: