Update a record on a table from a subfrom

[rogerarce]

I have a form where I input products to inventory(Inventory). I have one table called products, where I input information of the
products. Both tables have a price field. Now, How can I update a price from "inventory" to "products"? Let's say
that coca cola has already a price ($0.50). I'd like to have the price changed only if different from the one already in database?.

Thanks in advance for your help.

 

[WildHare]

I would think the ORDERS table should get the PRICE from the PRODUCTS table, and not be a separate field, unless the prices for the PRODUCT bear no real relation to the prices on the ORDER..

Codd's Rule #378 of Relational Databases: Never store the same piece of data in two separate places.



78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm