1 job, multiple customers. How do I make an accurate table?



My company is a supplier, so we submit our bid numbers to multiple
contractors for a single job. There are about 70 jobs a month.

Example. Job: Hostpital... Customers... apple, orange, and kiwi

How can I accuratly input this information (multiple customers for 1 job)
per job without messing up all my other jobs that I bid for that month?

I will gladly email my database



Larry Daugherty

Your target paradigm is a many-to-many relationship. To model it
requires a junction table which will have the Primary Keys from
tblCustomer and tblJob as Foreign Keys. You might name the new table
~tblJobsCustomers. There will be a record in that table for every
intersection of a job and a customer.



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