Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cqcdave
Starting Member
2 Posts |
 Posted - 2015-02-09 : 14:18:33
|
| I am using MS Access 2007.I have a form/table Customer Complaints with a field BSICustomerName. 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 in the Customer Complaints form/table. Either automatically or when i click the drop down menu on the BSICustomerID field it displays only the correct CustomerId for the customer.Thanks for your help, i'm VERY new to using msql. |
|
|
Grifter
Constraint Violating Yak Guru
274 Posts |
Posted - 2015-02-10 : 07:27:25
|
| So when you pick the customer name on the form you want to take the associated ID of that customer from the table and populate your form with that customer ID? |
 |
|
|
cqcdave
Starting Member
2 Posts |
Posted - 2015-02-10 : 08:38:53
|
| Yes, either that or after i select the customer name when i click on te drop down menu for the customer id the correct id is the only option. |
|
|
|
|
|
|
Query Question