Hello,

I am a novice at filemaker 8.5, but with the help of FM Forum have managed to create a successful invoicing solution for the company that i work for. This has been loosely based upon the business productivity pack. (See attached picture)

This solution has repeating field which i've heard are not the best.

However, my problem is that the management have asked me to re-design the system so that each customer will have an induvidual price for each of our products, approx 90 - 100 product in total.

My question is how do i form this relationship.

Many thanks.

Capture1.pdf

so that each customer will have an induvidual price for each of our products

How so? +/- % of base price structure? or individual price setting?

Benefit of +/- % structure:

1. base price can be changed in one place for all customers and their price will change automatically. This provides the greatest flexibity for your company in the marketplace where rising prices are the norm.

2. customers can be grouped and graded to determine pricing structure. The same can be done for product groupings.

3. no new table is needed (add field in customer table to hold the +/-% & add field in line items table to calculate the price to charge)

Individual price setting, I would seek to discourage any consideration. Not because it cannot be done, rather it is the black hole of evil from a maintenance standpoint.

Hope this Helps,

Tim