Hello everyone,

First, thank you for taking the time to read this plea for help.

Second... I am using the Estimates pre-made template in Filemaker Pro 12. On the estimate detail screen there is a portal to Estimate Data. There is also a button that will delete the specific portal row. I want to create a button that will duplicate the portal row. I've read others writing about bad data management, but the case is that I may have to order 5 variations of an item and I don't want to have to enter it in 5 times. I'd rather just click a button 5 times and create 5 portal rows and then make notes about the differences in the notes field I added.

I've tried a number of methods:

The select the next/previous portal row - then duplicating

Go to related record - but there is no layout appropriate

I want it to behave like the garbage can in the portal except it duplicates the row instead.

Thoughts?

When you duplicate a portal row you are creating a duplicate record in a related table, not the table on which your main record is based.

If your a member of TechNet - here is a wonderful technique that was from this past Devcon by Todd Geist its reusable code that allows you to duplicate an invoice this technique

isn't directly what you are after. But it's great education https://fmdev.filema...m/docs/DOC-2922

In your case just go to related record choose a utility layout (create one as needed ) perform the duplicate function return to original layout.

*However* you may wish to add more scripting instead of duplicating as a dupe may not update the unique record id.

In this case go to related set all the fields of the current record in to variables (including the parent id's ) create a NEW record then set fields to that of what is stored in the variables.

this way creating new will add the new id and when you set fields any other fields that lookup values will lookup values at that point in time - where duplicate may have stale data.

hope this helps.

Stephen