Hi Guys,
I hope I can explain this properly.
I have a stock and audit database setup with a folder called 'Outlets', within the outlets folder there are many sets of tables storing data for the various sites we work on.
In a separate database I have a scheduling setup which holds site details for all the outlets and I use this for scheduling work.
Currently, I manually enter the last date that the job was done, taken from the site table within the outlet folder, into the scheduling database and then the scheduling database produces a report which I use to fill my diary up.
Would it be possible to have the scheduling database reference the date held in the table of the site database?
The two databases have no relationship at all and are in different folders on the same computer. Can I persuade Access to reference a field in a table held in a different folder?
Thanks in advance for help.
I hope I can explain this properly.
I have a stock and audit database setup with a folder called 'Outlets', within the outlets folder there are many sets of tables storing data for the various sites we work on.
In a separate database I have a scheduling setup which holds site details for all the outlets and I use this for scheduling work.
Currently, I manually enter the last date that the job was done, taken from the site table within the outlet folder, into the scheduling database and then the scheduling database produces a report which I use to fill my diary up.
Would it be possible to have the scheduling database reference the date held in the table of the site database?
The two databases have no relationship at all and are in different folders on the same computer. Can I persuade Access to reference a field in a table held in a different folder?
Thanks in advance for help.