I have a table Customer Complaints with a field BSICustomerName it is a combo box 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 with the CustomerID from the Customer Information table. It can be either automatic or after I select BSICustomerName and then click on the menu for BSICustomerID the correct ID is the only option available. Any help would be appreciated.

Thanks...