Generate new set of record including multiple records
I have a calculation table C, where I got fields: Factory, Model, Price
In most cases one factory produce more than one model, and I need to make new orders and keep records of orders.
For example, in table C:
When I make order, I will first select factory, and I need to see all models under the same factory, then I will enter quantity for each model and a total price will be calculated.
After entering, all records will be save like following format in Table Order:
Factory Model Qty Total
A aa1 5 10
A aa2 10 30
I tried the link Phil sent me before, http://fmforums.com/forum/showpost.php?post/309136/. In this case, one ID reflects one product. How can I see all models in one layout linked with one factory and save all records?