Are you Familiar with this data model?
To sell product, you create a new record in Invoices, select the customer and then use a portal to LineItems to list the items sold to that customer in that specific sales transaction.
We can modify the above setup (just helped another poster with their set up for that), so that the type of customer determines the price returned. We can either have separate records in product for each Item-Price pairing or a new related table of just product Ids, Pricing Categories and prices can be used to produce the pricing lists.
But First I need confirmation on your basic set up here.
thanks for that bit of info...I'll have a look at my relationships and see if I can figure it out from
and write back if I have trouble.
Thanks again for your reply.
All the best