Actually I'm not sure if it's a relationship or a lookup. I am a total FMPro newbie. I have a database from a manufacturer that has product UPC codes and prices for those products. I have databases coming in from customers with the same product UPC codes and how many cases they ordered of each product but with no price attached. What I would like to do is have my customer database match it’s UPC code to the manufacturer’s database UPC code, then take the price associated with that upc code and put it into the customer’s database and then total the price of the product by its quantity. The last part is a simple calculation that I can handle, but I’m not sure how to go about getting the price into the customer’s database. Any help would be greatly appreciated.

There is no need to put the price in the customer Database, unless you want to send it back to the customer, then you would need to import all of the companies products. Anyhow.

Just relate the tables by that UPC Code. Then, to get the total price for the customer, Create a calc field cTotal_Price. Define it as:

CompDATABASE::PRICE * CUSTDB::Units_Ordered.

Thanks for the help. I was able to get the price into the customer database using a relationship, which I needed to do, but when I go into list view I get a little label named price besides every entry. How can I turn this off?