Copying a record and its portal issue
I have a button set up that allows users to copy an existing purchase order (and its line items) to a new purchase order. I use the method that uses exporting to and importing from a temp.tab file. Here's my issue:
- The Line items database uses lookups from a Catalog database to retrieve the price of an item.
- The user can change that looked-up price.
- When the user clicks the "Copy PO" button, Filemaker exports an imports the line itemsl; but then afterwards, re-performs the lookup and changes all of the prices to their default values. :(
Is there any way to prevent Filemaker from performing the lookup when I am copying a PO?