show 2 names in list

  • Thread starter Thread starter Boze
  • Start date Start date
B

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
 
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
 
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
 
Back
Top