Copy a record and all related records

[Ann B]

I have a layout with a portal. and I want my user to be able to click a button and copy not only the data from the current record, but all the related records into a new record. Can anyone help me with this?

So main table: Physician Order with the fields date issued, physician name, etc.

Related table: Short term goals, linked to Physician Order on Physician Order ID. One current Physician Order can have multiple short term goals, and we want to copy the current Physician Order with short term goals, and just have the user change the Date Issued field.

I am pretty new to Filemaker (sorry).

Thanks!

[mr_vodka]

Perhaps this article can help you.

Duplicating Parent Record and Portal Child Records