Search results for query: *

I have a many to many relationship, With many projects and many partners, each partner can work on many projects, each project can have many partners. The problem I have is that I need to create a subform in the projects form to enter the partners. I need to create a combo box that allow me to...

my email address is RichardLashford2002@yahoo.com Thanks alot I really appreciate it. Richard

i can do that but then I am entering a new partner name in each time. For each project I want to be able to select a multiple number of partners from drop downlists. The only way I have found of doing this is by making the partners ID and Project ID fields in the link table a combo box of...

What you are saying makes alot of sense How do I make the combo table look up the partner name though If i just called partner name a combo list then there are no names there to select from any ideas??

I have tried to do that but it seems to set things up as a one to many relationship and not a many to many. As when I enter a partner name it enters a new one everytime. So i dont so much need to input the partners ( i can do this elsewhere, rather I jsut need to link them to that particular...

Basically how do I make a form that lets me assign a partner to a project? Given that there will be a variable number of partners per project. I can input the partners names in a seperate form. This shouldn't be as complicated as all this should it??

thanks for the reply. How exactly would I do the forms? I am still don't see how the many to many relationship works. How does the link table get populated? Sorry for all the questions. Richard

I am in desperate need of a reality check on a database I am trying to set up. My company bids for many projects. On each bid we have many partners. But each partner can be on many other bids. ( there is much more information that I want to store, such as varying number of contacts for each...