Duplicating an Invoice Problem

[JJAW]

We currently use Filemaker 8.5. We have a number of repeat customers. Instead of creating a new invoice I often duplicate a previous invoice. The problem I have is our costs on items change. Right know when I duplicate a record it duplicates with the cost of the old record and doesn't update the record with our current costs.

I have to re-enter the item number of the item to get the current cost to show.

Any quick fix to this?

[Fenton]

I don't really see how you'd have 1 product per Invoice, as you imply. Perhaps so. If so, just Set Field [ product ID, product ID ], then Exit Record, to bring in the current cost. Which is the same as what you're doing manually.

[JJAW]

We have a total of 8 lines of products we can enter. The product costs are not updating to our current cost on any of the lines.

[Søren Dyhr]

How come the newly created invoice isn't the opposite of orphaned ... deprived, childrecords shouldn't exist at all since the autoenter in the parentID would lack matching.

How come only 8 lines exists, where the products are entered.

You're giving yourself away here, shouldn't it be repeating fields you are using here??

Invoicing from fm3 and upwards should instead go by this principle:

http://www.filemakerpros.com/joinprint.sit

Duplicating a structure as this would require, some scripting in both the tables involved, alternatively could Applescripting deal with both tables in one single command!

--sd