show 2 names in list

[Boze]

I'm making a form for our companies items. I want to list the Vendor that
we purchase the item from. In some cases there are 2 Vendors because the
item is a combination of 2 components. Any suggestions on how to show both
Vendors for one item? I currently have the Vendors listed in a combo box
dropdown.

Thanks in advance
Boze

 

[Guest]

You need a Listbox or a subform if you want them all to be listed at the same
time. A listbox is easier if you just want to look at the list. A subform is
best if you need to do inserts, updates etc. on the listed items.
Look in Access help for how to set these up.
- Dorian

 

[Boze]

Thanks. I've been trying to get this to work but I think my problem goes
back to table design? I have
tblItems with foreign key VendorID
tblVendor with primary key VendorID
I need to figure out what to change so I can have more than one vendor for
each item. I know I don't want VendorID1, VendorID2, VendorID3 but that's
as far as I've gotten so far. I'll read in the tabledesign forum to see if
that's what I need to fix before I work on fixing the form

Thanks again for the reply
Boze