Look Up Value

[Export Girl]

Please help. I am using a subform that is supposed to automatically populate
a price by UPC code and Shipping Method.

Table one has all UPC codes and the different pricing for each product,
depending on how the product will be shipped. I would like the used to
choose the UPC code (from a cbo), choose shipping method from a cbo and the
SSP to populate as the end result.

Thanks!

 

[[MVP] S.Clark]

Examine the northwind example database. It does something very similar.

 

[Export Girl]

Steve,

Perhaps I am missing something in the Northwinds example. When I reviewed
it, I noticed that the price of a product is a fixed price. My pricing
varies. I have 4 tiers that pricing is based on; FOB QD, FOB FL China, Full
40 Delivered, and Full 4o Consolidated.

I have 10,000 different products. The difference in pricing between the
tiers is never a fixed amount. In my subform, the user would choose a
product, choose the loading method and the SSP would populate.

In my products table, I have the 4 different prices. I need accees to
choose the correct price based on the type of loading and product that the
user chose.

Thanks,

Sara