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.
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