Duplicate a portal row

[MERLIN_ti]

Hi,

I got a simple database that include 3 layout (job info, submission and billing information). In the job layout i got 2 portals rows (1 for submission and the other for the billing) i just want to know how to copy all the portal row of submission of a job to the billing portal row of the billing of the same job. I don't want to rewrite each time exactly the same information. i'm sure that a simple script can do that.

Thanks for your time

MERLIN_ti

[DannyDK]

It would probably be best not to duplicate the information at all, but rather to use relationships to share the information. If you set up a relationship between the billing and the submission tables, you can use the submission data from the context of the billing table.