I have three tables COMPANYTBL, PROJECTTBL, SOURCETBL – one form PROJECTFRM – one update query SOURCEQRY
COMPANYTBL and PROJECTTBL are linked to each other via a field so that it is possible to see only the projects for a particular company when using PROJECTFM.
SOURCETBL holds a preset number of records which need to be transfered to PROJECTTBL (I have done this using SOURCEQRY) whenever a new project is started.
When a new project is started the data from SOURCETBL needs to be transfered to PROJECTTBL for the company which the project is for.
The problem is when the update query is run, it does not fill in the field which links PROJECTTBL with COMPANYTBL.
The query is run from a button on PROJECTFM which is filtered to show only one company’s record.
Is there a way that I can get it to add the data from a field on PROJECTFM to a specific field in PROJECTTBL for each record that is transfered when SOURCEQRY is run? so that they are linked to the right Company.