I'm a beginner when it comes to FM but love to learn
I have an Order table with a portal containing individual items (Let's call it Sales Table).
So each order record contain few items in the portal.
I want to define the type or order, let's say Paid or Free but I want to be able to have that definition associated to the items so i can invoice them.
However sometime in the order I may have one of the item that is free and I give as a bonus.
So technically the definition shouldn't be attached to the order but to the individual items.
What would be the best way to define them with once and eventually modify the individual status of the only items that are different.
Hope this is clear
Clear, more or less; however, as a general principle, the items should inherit the type of order to start with, then allow it to be modified individually. Looks like a field on the item which is lookuped but modifiable.