General Setup - Please advise me

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
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top