Thanks in advance for anyone who can provide me with some help.
I am completely stumped. I haven't used Access to design anything more than a simple database with separate tables in over a year. I have been sitting here for hours trying to link the data between several tables on 2 separate databases.
I have a database which I use for keeping track of the status of documents from different dates. Every couple of weeks a new load of documents come in and I have to create a new table on my database to keep track of the documents that are being translated.
Now, we have another database with its own table that contains every document that we have ever received. I need to design the database so that I can link the data on all my tables on my database with the data on the other table on the other database. So that whenever I update something on one of my tables, it is automatically updated on the other database. You may think this is useless and that I may as well just keep the tables on the same database, but this is what the boss wants… so I have to deliver.
I will give you an example of what is needed:
Database 1
Table 1
Table 2
Table 3
Table 4
Table 5
Database 2
Table 1
Everything on database 1 needs to automatically update on database 2 whenever something is changed/added/deleted.
To anyone who can help… you are an absolute legend. I have been trying to figure this out for so long.