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

G

Guest

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
 
L

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.

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

How and where to get started? Database for bid management 2
Attempting an inventory management database 7
how do i update a table using a form? 1
How do I find what error a print job has run into? 2
How do I total entries for a row 5
To me this is huge, need some assistance 1
Formatting Multiple Worksheets 1
How do I make an update query that uses multiple tables? 3

Top