OK I'm stump.Hopefully this is the correct forum for this post.

I have to modify or create a new invoice db that can provide custom line item prices based on customer.

So I have a typical db structure Customer, Invoice, LineItem and Inventory db's all with the proper links and portals, but here is my issue.

This is a table representing items broken down by Item# and different size (A,B,C and D). Item numbers are a range for example 1000 thrugh 1999 is a range of item numbers each with different description.

Customer A

Item# ----- A ------B------C--------D

1000-1999 $2.00 $3.00 $1.50 $2.50

2000-2999 $5.00 $8.00 $2.00 $3.50

3000-3999 $6.00 $7.00 $4.00 $4.00

So when I create an Invoice for customer A and input the number 1001 in the Item# and size A I would whant the price field to be $2.00 populated automatically. For the 2nd item if I would to put item number 2500 in the item# field with size D I would want the price field to be automatically populated with $3.50 and so on. This table represents the prices for customer A but the price will vary depanding on customer.

So customer B may be

Item#-------- A------ B------ C-----D

1000-1999 $1.75 $2.50 $1.00 $3.00

2000-2999 $4.00 $9.00 $3.00 $4.50

3000-3999 $6.50 $8.00 $4.50 $5.00

I just can't put it together. I've done simple invoice were the price is the same through out but this one is tough.

Any help would be appreciated!

how abot relating another table eg. 'ItemSizes' and relating it to Items by ItemID.

You could have a related drop down (or any other form object of choice) that would hold sizes..A,B,C and corresponsing values/prices.

All the best!

Thanks

I beleive I found the solution. Couple GetRepetition and few lookups did the job! :P