I'm new in Filemaker database. I have created a database to manage custom formulation of products. The database contains many tables, such as ingredients, customers, invoices, formulation. Formulation table contains a protal which showing records of specific 'formulation name' with many ingredients in it. When a customer ordering that particular formulation which most likely will add or subtract some of the ingredients already input in the 'Formulation table'. In the customer order table/layout, I would like to first retrieve all the ingredients from the portal of 'formulation table' layout and input into a new portal in the customer order table layout, then from there, I can add or delete specific ingredient, and finally base on the final ingredients listed in the portal in the customer order table, calculated the cost of that custom formulation and send out invoice.
Can you show me how to do it?