Hello all and in advance thank you once again for your help.
i have several databases on a shared network, one for each location in our buisiness unit. what i am forseeing is that for the lead in this department i was thinking of giving a database that is linked to each individual database, that part is simple. my problem comes with the queries. each database has three tables lets say. they track the shift in the first, the object consumed in the second and the objects created from the first master object in the third. this works great in the individual databases because i have the ID's set up and it all links great in the queries. if i link all the different databases into a common database for the lead to be able to monitor the days activity how do i work the queries since each is identical just from a different location. surely someone here is currently doing this and has some do's and don'ts.