J
jag
I'm not an expert at Access, nor a novice. Sort of in between - so I
thought. Anyway, here is my problem. I have obviously confused myself. I
have a db I created that I cannot get the relationships correctly sorted in
my mind.
There are several tables, but the entire db in based on a service address,
rather than a client. The tables are listed below according to their
priority:
1. Service Address - a request is made for service at an address.
2. Work Order - a work order is entered based on the service add.
3. Permit - a permit is sometimes required for a service address. Work
orders will be created for the permits to the service address.
4. Job# - Some times there are job numbers assigned to the larger projects.
Eventually work orders will be created for the jobs.
5. Customer information - sometimes the work orders are requested by a
caller, but not always. Sometimes the work orders are requested internally.
But, customer information is always required for a permit.
Now, this is my confusion on the relationships.
Service Address table - ServID: 1 to many with the Work Order DB ServID
Work Order table - WOrderID : 1 to many with Permit WOrder ID
1 to many with Job# WOrderID
?1 to many with Customer with WorkORderID?
Permit table: - 1 to many with Work Order WOrderID
?1 to many with Customer PermitID?
When I try to make the 1 to many for the Permit and WOrder to the Customer,
I get an error relating to referential. Can anyone advise if these
relationships are wrong?
thought. Anyway, here is my problem. I have obviously confused myself. I
have a db I created that I cannot get the relationships correctly sorted in
my mind.
There are several tables, but the entire db in based on a service address,
rather than a client. The tables are listed below according to their
priority:
1. Service Address - a request is made for service at an address.
2. Work Order - a work order is entered based on the service add.
3. Permit - a permit is sometimes required for a service address. Work
orders will be created for the permits to the service address.
4. Job# - Some times there are job numbers assigned to the larger projects.
Eventually work orders will be created for the jobs.
5. Customer information - sometimes the work orders are requested by a
caller, but not always. Sometimes the work orders are requested internally.
But, customer information is always required for a permit.
Now, this is my confusion on the relationships.
Service Address table - ServID: 1 to many with the Work Order DB ServID
Work Order table - WOrderID : 1 to many with Permit WOrder ID
1 to many with Job# WOrderID
?1 to many with Customer with WorkORderID?
Permit table: - 1 to many with Work Order WOrderID
?1 to many with Customer PermitID?
When I try to make the 1 to many for the Permit and WOrder to the Customer,
I get an error relating to referential. Can anyone advise if these
relationships are wrong?