autolookup query

[Guest]

I'm trying to make an autolookup query for a subform that pulls information
from 2 tables and inserts it into another. The Problem I'm running into is
the ablity to add a new record when I have the information.

My tables are as follows (simplified of course):
Products
ProductID (key)
ProductDescription

Quote
ShipTo (key)
ProductID (joined to ProductID in Products)(key)

ProductsOrdered
ShipTo
Quanity
ProductID (Joined to ProductID in Quote)
ProductDescription

Can anyone Help?

 

[Duane Hookom]

There is no reason to store the ProductDescription in the ProductsOrdered
table. Look at the Northwind sample database.

Is that what you were expecting? The Northwind (I believe) does have some
code that pulls unitprice or something from a product table and stores it in
the OrderDetails table. This is only because the price of the product may
change over time and the OrderDetails price should not change.