Ryan,
Without knowing how much business process follows after you have got a Job fully described it is hard to be sure of the right architecture. However based upon what you said so far, the second option of two relationships is the easiest. I would rename the reference fields in the Breakers Table to Related Panel and Related Load. This way you explicitly know which of the two Parent Packages has a particular function for the Job.
I am assuming that a particular Job has multiple packages
- Job with RID 1, Job Name = Acme Rebuild
- Package RID1, Package Name = Southside Panel
- Related Equipment Type =1 (Panel)
- Related Job =1
- Package RID 2, Package Name = Air Compressor Isolation Transformer
- Related Equipment Type = 2 (Transformers)
- Related Job = 1
- Breaker Table RID 1
- Breaker Name = Siemens 100 Amp 3 Pole
- Related Panel =1
- Related Load =2
To help avoid selecting the wrong Load you can use a Conditional Drop Down so that the
- Related Panel Related Job = Related Load Related Job
This is not perfect as you can select any Package from that Job but at least you wont see choices from other Jobs.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
