Hi, Im a new member having problems...
I have 6 tables in my DB. 1 table for each calender year. All tables contain the same feilds. In one particular field stores the serial number of a machine. Another contains a job number generated by Access (auto-number).
I wish to be able to search on the serial number to display all the related job numbers in another table/form.
Do I build a query for each table?
How can I stop each query running independently in a form one after the other which require me to type in the serial number in to the dialog box each time?
Am I approaching this from the wrong angle?
Any help on this would be much appreciated.
I have 6 tables in my DB. 1 table for each calender year. All tables contain the same feilds. In one particular field stores the serial number of a machine. Another contains a job number generated by Access (auto-number).
I wish to be able to search on the serial number to display all the related job numbers in another table/form.
Do I build a query for each table?
How can I stop each query running independently in a form one after the other which require me to type in the serial number in to the dialog box each time?
Am I approaching this from the wrong angle?
Any help on this would be much appreciated.
