Append Query matching fields

[gowans07]

Trying to create an append query which will take details from a form. In the form i have the field Customer Name. The table in which will be appended has Customer ID. I have another table (Tbl_Customer) which holds ID and Name, is there anyway to match the appropriate records and then save the ID?

Hope i've explained that correctly. Thanks

TG

 

[jzwp22]

Instead of using a textbox control for the customer name, why don't you use a combo box and include both the customer name and customerID in the combo box. You would set the bound field of the combo box to the customerID and then you can just reference the combo box control in your append query (no need for matching). Also, you would avoid the hassle of misspelled customer names.

By the way the word "name" should not be used as a field or table name since it is a reserved word in Access.

 

[gowans07]

Okay that would work, found another way of performing it by creating a normal select query and then running that in the append query seems to do the job.

In the customer table the fields are, Customer ID and Customer Name. Couldnt be bothered to write them out fully earlier. Thanks for quick reply.

 

[jzwp22]

Glad you found a solution.