Please don't start a new thread on the same topic.
I didn't feel I was clear enough on my other post.
What should I do now to clear this up?
Sorry about the inconvenience.
Well to get this info to copy to another table you would have to set variables and have fields in your other table equal the variable. So a script would have to run when the + is selected.
Set all your variables first.
Then set field command when you enter the line item table.
Set Variable $itemName; Value: Products::Itemname
Go to Layout[Line Item Table]
Set Field [LineItem:: ItemName; $itemName]
This will copy the value but wont solve your issue with multiple quantities. There would have to be some sort of check in place for duplicate.
If Item ID exists then add +1 to quantity field. <-- not in filemaker syntex but you get the idea behind the logic.
Then a calculation for the price would have to be quantity x price to = Total
Total field on the line item layout would be a calculation field.
Thanks for your help