List Box vs. Combo Box

[bsdixon]

I have a form where I select a vendor name out of a combo box.

The rest of the vendor information then defaults into combo boxes below. I want these to actually be list boxes so that the user does not have to select the rest of the vendor information. The only problem is that when I turn them into list boxes the data does not save into the underlying table. How do I get the list box information to save??

 

[bsdixon]

The only problem is that I somtimes need 4 of these vendors to show up as one record on a report.

I thought that I might need to add address2, vendor2, city2... fields to my table so that I can get the report to show the four vendors.

Is there any other way for 4 vendors to be assigned to one contract and then have all 4 vendors information pull on to one record of a report?