Access form & table setup

[Kevin]

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

 

[Steve Schapel]

Kevin,

OK, apparently each Vendor can be associated with more than one
Project. Does each Project only have one Vendor, or can/does a
Project have more than one Vendor?

- Steve Schapel, Microsoft Access MVP