Hello
We got to work in MS Access with creating this database for a company. Anyway I have a problem with a form where I will registrate new Products cause I don't want to have one of the secondary keys in the form even, but it keeps telling me I need to fill in a related post in the table for that secondary key
Table 1 (used for keeping track of products)
ART_NR (primary key)
product_name
product_type
prduct_price
MANU_ID (foreign key) - this one is the one I want to have there
CUSTOMER_ID (foreign key) - this is the one I don't want to be needing to fill in each time.
The customer_id I need to have in Table 1 cause there is a request for being able to look up which instruments customers are ordering. But the problem is I can't create a Form-Open form without needing to fill in something at Customer_ID which require me to fill in something at Table 2 - Customer... if I don't, I get an error saying I need to fill out the info in Customer which CUSTOMER_ID referes to.
Anyone know where and how to either turn off the foreign key for this form and only that foreign key, or how to delete it from the form?
Need help fast!
/Melotron the dragonknight