microsoft access course - How do I link 2 seperate databases to produce one result without

Hi Clive

I trust that you found your Access Intermediate course useful.

Firstly start by linking both your tables together, to do this make sure that you have a primary key field in each table i.e. id, then one of the tables will need to contain a field that is the primary key of the other table. By this I mean if you have a customer table and an order table, there may be many orders per customer. So you would have a custID as the primary key in the customer table and in the order table you will have a primary key of orderID, but also a foreign key of custID.

Once the table is set up is complete you can then link the tables by creating a relationship between them. Once this is down you can create a query that will bring back all the information that you want i.e. all orders for all customers.

Hope this solves you MS access database question
David