Copy related records

[Bill_misc_IT]

I have a product catalog solution [Database A] that consists of a "master" record and several related records through a parent-child relationship.  

A separate solution [Database B] tracks shipping/receiving of these products.  I would like to create daily records in this separate solution (B), and copy information via a related field with the catalog (A).  **Easily done via lookup or auto entry calculation.**   In addition, I would like "replicate" the related records, via the parent-child relationship, so that the shipping/receiving solution has the same related records as the product catalog solution.  In other words:

MasterRecord1  -->  ChildRecord1

                              -->  ChildRecord2

                              -->  ChildRecord3

------------------------------------------------------

Shipping/ReceivingRecord1 (Related to MasterRecord1)

Create/copy information to result with     -->ChildRecord1a

                                                                          -->ChildRecord1b

                                                                          -->ChildRecord1c

[Steve Martino]

Most people would not recommend duplicating the records.  why do you need them in both databases, 2 tables?  Why not just put a portal and if needed a relationship to show the related records in the other table?

Another question is why the 2 databases?  Just curious.

[Lee Smith]

Hi Bill,

Are you trying to make a report from a portal?

If so, you should make your reports in the Table where the original Data Resides.