Customer can also have multiple jobs. (1 to many)
I have a Jobs table and each Job can have only one location.(1 to one)
For each JobLocation they can have multiple chillers. (1 to many relationship)
I'm trying to create a form which will allow me to enter in a job, then the Job Location and all the information about the chillers at that location.
I believe I need an intermediate table between Locations and Chiller Information to do this, but I can't seem to define the relationships the way I want.
Attached a couple of screen shots of what I'm attempting to do. Please help.
I have a Jobs table and each Job can have only one location.(1 to one)
For each JobLocation they can have multiple chillers. (1 to many relationship)
I'm trying to create a form which will allow me to enter in a job, then the Job Location and all the information about the chillers at that location.
I believe I need an intermediate table between Locations and Chiller Information to do this, but I can't seem to define the relationships the way I want.
Attached a couple of screen shots of what I'm attempting to do. Please help.