This may work, but it means that each dealer can never have more than one car, and each car can never have more than one job.

mmcdonal

Oh uh, I need Dealers to be able to have multiple jobs.

If JobNumberis the PK I thought the rest of the entries in that table could be duplicated.

Any suggestions on how to fix this problem?

Create a Dealer table with a DealerID as PK
Create a Car table with CarID as PK, and DealerID as FK
Create a Job table with JobID as PK, and CarID as FK

This will allow you to have many dealers, each one havig many cars, and each car having many jobs.
If you would like a single car serviced by many dealers, then that will require a DealerID FK in the job table.

mmcdonal

Thank you so much!!!