Return to FileMaker.com
Hi, I still working on invoice filmmaker starter solution and I see a relation between invoice data and products look up.
please explain to me why we do this work? when we use to look up and anything you know I must know about this.
Haven't got the Starter solution in front of me, but I would guess that the Line Items (InvoiceData) table looks up (copies) the product price to store its value at the time of invoice creation.
If instead it would reference the value, then later price changes would falsify older invoices.
Retrieving data ...