I have a custom record ("Insurance Carrier") and on these records I need to have a list of inventory item and pricing. To explain: We charge a different amount for our products depending on what insurance our customers have. There are too many options to create pricing groups to accomplish what we need.
What I would like to have is a 'Machine' (like the line item machine in the sales order) that would allow me to choose an item, then in the next column enter a price for this item.
I will need to define several of these items for each insurance carrier record.
I've experimented with the "Record is Parent" option but find it a bit confusing. If I'm doing it correctly, it seems that I need to add a field on the CHILD record in order to get the list to appear on the parent record. This seems backwards to me and I suspect I'm doing something wrong.
In order to store the association between an existing item and a insurance carrier specific price I would need to create an association record (table) to store this. Do I have that correct?
If I'm missing something please straighten me out