AnsweredAssumed Answered

Linking Databases

Question asked by RichardGrant on Sep 22, 2011
Latest reply on Sep 23, 2011 by RichardGrant

Title

Linking Databases

Post

 We have several products and each has it on Database with 1 to 3 tables. When we create an order to sell we can have several products in the order and there could be several of the same products.

What I am looking to do is generate one document that lists all the Seral Numbers of all the products on the order.

I have create a new Database that has the information I need from the original databases by linking in the relationship by order number.

PROBLEM:

when tring to bring in records for multiple products of the same type I only have the 1 order number so the relationship only brings in the first record that mactch the order number     

Outcomes