Bound & Unbound Fields

[nellyville]

Hi

I am trying to use 3 different tables to create an enquiry form/table

I have the following tables
customer data
product data
and I am using a form to create enquiries I receive into an enquiry table

I have managed to link the customer data so that when I select a customer from a combo box it brings in customer details such as shipping details, customer contact, email etc

I now want to do the same with the product code, so that I create a combo box and the part code drops down so I can select it, then I want it to bring in product data such as description. I can make the combo box work but am unable to assign a control to make it a bound box because the control I would use "ID" does not show even though I have brought it in when I created the combo!

hope the above is clear enough for someone to help me )

Thanks

 

[bob fitz]

The "Enquiry" table needs a foreign key field to hold the primary key of the related customer table and a foreign key field to hold the primary key of the related products table. The combo boxes used on the enquiry form for customer and product should be bound to the foreign key fields of the enquiry table. The combo boxes should have the primary key as the first column but the first column width should be set to 0cm so it will not show in the combo box.

 

[nellyville]

hi Bob, thanks for your help. Although I didn't understand what a foreign key was, I went onto Microsoft site and understood that - your response worked

Thanks a million
Rgds
Nellyville

 

[nellyville]

Another question is how do I get the results of my form to store in my table 'Tbl_enquirys'

 

[gemma-the-husky]

the thing is that a customer and a product will not be linked directly

they will be linked via another table which will be an "orders" table say.

you need to create an orders table, linked to your cutomers, and also linked to the products. In general terms you normally have an order headers table, and an ordered items table.

this way,all the data becomes linked together.

hope this helps

 

[bob fitz]

Another question is how do I get the results of my form to store in my table 'Tbl_enquirys'

Bind the form to the table 'Tbl_enquirys' by setting the forms Record Source property and then set the Control Source property of each control to a field in that table.