"when i duplicate my master table to create a new one ..."
Are you really duplicating the entire table or just a record in the master table?
If just a record, what kind of data do you store in this table? Is this your master list of items and their prices?
Sorry just the records, the fields row are:
description | printer use | media | media price | sizew | sizeL | extras | extraprice | qty extra | punit | ptotal
- description, sizew, sizeL, qty extras: are wrote directly on the master table
- printer use, media, media price, extras, estra price: are related to product file to the lineitem table from the master file
- punit ptotal are calculation
It's hard to follow your description but I think you are duplicating an invoice record and find that the line items don't also duplicate?
That's expected Filemaker behavior. You'd need to add a script to find and duplicate the line item records also.
Yes, thats what happen, the lineitems don't duplicate, and yes I need a script to do that, can I send the file to you?
Um, well that's what I do for living, at some point, I have to draw the line and ask for payment. If I'm to develop a solution for you, that would be work right? :smileywink: If that's what you want, click my forum name and send me a private message and we'll discuss this.
On the other hand, if you want to do this yourself, look up information on Go To Related Records. This is a step that can be used to isolate the related records in a found set so that your script can loop through them and make duplicates.
Go To Related Records is a very useful tool, but which is very poorly documented. To learn more about GTRR, click the following link:
The Complete Go To Related Record
Yes i guest the fee, let me read this link and tryed 1 more time.