Does any one know if this is duable?

I have 4 FileMaker db's 1)Invoice 2)LineItem 3)Inventory 4)Customer

Items in the inventory db contain products that come in 3 different sizes.

Problem

The price on the items I sell are different for each customer.

I'm attempting to have the invoice automatically give the correct price base on the customer.

Any ideas??

Here's a thought. This will work if each individual customer has a price increased by the same percent for each product.

Give each customer a field called Percent Markup. Make it a lookup field in your line items. Then your cost would have the formula:

Cost = Unit Price x (1+Percent Markup Field)

Just don't show the Percent Markup Field on your invoice...the customer might get suspicious.

That's the thought I had for now. Good Luck!

------------------

Ryan

[email protected]

Hi,

1. You need the information of the size in the Customer file.

In the Inventory: you have three diferent Records for each size?, or you have each product with the three prices ? I