Intermediate - pro help ASAP!

[Guest]

PROJECT CUSTOMER Quote
Job A DynaTen 110701
TMC
DuctWorks
Job B Apple 110702
TMC
Job C Orange 110703

For each job there are multiple customers. I have a table set up for each
one so that when I enter the customer name in the system it pops up who the
customer is email address fax and so on. Is there a quick way so that each
job can have multiple customers without messing up my relationship in Access?

Keep in mind I am new at access. I need a detailed step by step detailed
instruction on how to do this... OR... I can just give you the file and you
can help me fix it from there.

Thank you everyone

 

[Dirk Goldgar]

In

PROJECT CUSTOMER Quote
Job A DynaTen 110701
TMC
DuctWorks
Job B Apple 110702
TMC
Job C Orange 110703

For each job there are multiple customers. I have a table set up for
each one so that when I enter the customer name in the system it pops
up who the customer is email address fax and so on. Is there a quick
way so that each job can have multiple customers without messing up
my relationship in Access?

Keep in mind I am new at access. I need a detailed step by step
detailed instruction on how to do this... OR... I can just give you
the file and you can help me fix it from there.

You need to have (at least) three tables: a table of Projects (or Jobs,
if that's an alternative name for the same thing), a table of Customers,
and a table of ProjectsCustomers. This last table is a linking table,
with one record per project+customer combination. Each record would
have one field that holds the key to the Project, and one field that
holds the key to the Customer.

 

[Douglas J. Steele]

Are you saying that you have a different table for each customer? That's
seldom (if ever) a good idea.

 

[Guest]

I do not see how you can have three customer for one job. Also how can you
have one quote for three customers?
Seems like you need three tables in a one-to-many relationship -- Job/Qoute
to Job_Cust and Customers to Job_Cust.
Jobs --
JobID - autonumber - primary key
JobName - text
Quote - number - single

Customers --
CustID - autonumber - Primary
Name - text
Addr1 - text
Addr2 - text
City - text
State - text
Zip - text
Phone - text

Job_Cust --
JobID - number - integer
CustID - number - integer