Query Question

[CQCDave]

I have a table Customer Complaints with e field BSICustomerName it is a combo field with a query attached to it. It looks to the Customer Information table to select the customer name. When i select the customer name from the Customer Information table i want to also populate the BSICustomerID field on the Customer Complaints form.

I am pretty new to access and working my way through this any help would be greatly appreciated. I am using MS Access 2010.

Thanks...

[June7]

What do you mean by 'combo field'? Have you built lookups in table? Advise not to do that. http://access.mvps.org/access/lookupfields.htm

Options:

1. form bound to Customer_Complaints table and a combobox to select customer

2. form/subform arrangement

This is basic Access functionality. Have you completed an introductory tutorial book?