Ok,  Can anyone tell me if this is even possible?

 

I have a fairly simple invoice solution... With one very troublesome issue.

I have customer table, product and invoice table.

I have an issue though that each product is base: Widgets, Gidgets, Gadgets, etc

But on each and every widget I have a modification that I have to make:  XL, engraved, Blue/Red, etc. along with notes for the invoice.

But when I pull the records into the invoice in the portal and I allow modification in browse mode anything I type into one product

automatically changes all like products.

Ex:  LINE #1:  Widget:  XL, Blue. Engraved.

 If I enter another Widget it automatically changes the previous entries on the invoice that share same product name/id.

Is there anyway to not have it do this?

Appreciate any insight,

Thanks.

Hi!  Welcome to FMForums!!  :-)

 

You are missing a critical table - LineItems.  This is where you enter the items being purchased in a 1-to-many setup off of the Invoice.  It inserts only the selected ProductID and then looks up the price from the Products table.

 

Here is an example of a perfect configuration.

 

http://fmforums.com/forum/topic/63425-auto-fill-one-field-with-text-from-two-fields/#entry300150