General Setup - Please advise me

  • Thread starter Thread starter kwilson
  • Start date Start date
K

kwilson

Hello, Access 2000,Xp Profesional, need help is setting up
table / form for input of data.

large number of vendors on "Vendor Table" and 20 project
on "Project Table".

I need to assign a single vendor to mulitple project using
a form. Button would be okay and listing the projects.
however where and how is the best way to store data.

Any feed back would be appreciated.

Thank you

Kevin
 
Kevin, you say that one vendor can be assigned to multiple projects.
I'm guessing that one project can also have multiple vendors?

If so, you have the classic many-to-many relationship between vendors and
projects. To resolve that, you need a 3rd table - say "ProjectVendor". It
contains these fields:
ProjectID foreign key to Project.ProjectID
VendorID foreign key to Vendor.VendorID

The interface is a main form for Vendor, with a subform bound to
ProjectVendor. The continuous subform contains a combo box where the user
can choose the ProjectID. Where the vendor is involved in multiple projects,
select one per line in the continuous subform.
 
Back
Top