-
SQL question
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|