Linking Database records

[Peter Bellamy]

Here is a little puzzle for you !

I have built a couple of independant databases for our production facility.
One is for recording all the build details we need for traceabilty of the built product.
The other is to record the reciept of returned goods and the actions taken.

I now want to link them together so all the information is available together.
The key records that would be common in both are the product name and the product serial number.

I could import all the tables etc from one into another and then set about 'combining' the forms and build re;ationships etc. A big job.

Alternative I wondered if there was a way I could add a record to each Db table that could be used to make the link to the other Db. Bearing in mind that this would have to be made in a simple way for non-Db literate users to be able to use.

Cheers
Peter

 

[tehNellie]

you could look to combine both Databases table structures into a single back end and link the necessary tables to your current forms/queries etc that currently exist in the two seaparate databases. You should be able to do this with minimal changes to what you've currently got and thenlook to merge the functionality into a single application front end over a longer time.

 

[Peter Bellamy]

They both Front End / Back End Dbs so what you have suggested is the same as my first thought.

I just hoped there might be a quicker/easier way !