I have a list of companies who have corresponding id numbers. Each company name is unique, but may have more than one id number.
I have one tabe, osi_name, that is an autonumber and the company name
I have another table, osi_no, that is 2 fields, the first field, key is tied to the autonumber in osi_name, and the second field is osi_num, the corresponding id number. there is also a third table for notes and contact info, but is unimportant here.
I need to build a query that will:
-take all osi_num values for a given key value in the osi_num table and store them in such a manner that I can insert them into a form in a text box when a related osi_name is selected from a combo box on the same form.
All help is appreciated.
I have one tabe, osi_name, that is an autonumber and the company name
I have another table, osi_no, that is 2 fields, the first field, key is tied to the autonumber in osi_name, and the second field is osi_num, the corresponding id number. there is also a third table for notes and contact info, but is unimportant here.
I need to build a query that will:
-take all osi_num values for a given key value in the osi_num table and store them in such a manner that I can insert them into a form in a text box when a related osi_name is selected from a combo box on the same form.
All help is appreciated.
