Many to Many and Sales Order

S

SAC

I have a many to many relationship. Organizations can have many people and
People can have many organizations. So, I have three tables:

People
Organizations
PeoOrg

All is well.

I add a Sales Order table and I'd like to have a form where I can add a
Sales Order, have a dropdown box for the organization and a dropdown box for
the person (showing only those people for the Organization I chose.) Should
I have a foreign field for Organization ID and a separate on for PeopleID or
how do I do this?

Thanks.
 
G

George Nicholson

If, as you state, People can have many Organizations, then I would think you
need Foreign keys for both Organization and People.

HTH,
 

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

Similar Threads

query problem 2
Many-to-many relationship problem 1
Access Implementation 4
complex query 1
Need ideas for a search 5
Subform data not showing up 1
Working with many-to-many relationships in Access 2007 4
Database design many to many relationships 4

Top