I’m a little unclear on theory here.
I have a number of tables but specifically…
clients
placements
facilities
A client may have only 1 placement
A placement may have only 1 client but there may be many placements per
client.
A placement may have only 1 facility
A facility may have only 1 placement but there may be many placements
per facility
I’m wondering if it is necessary to store a facility relation in the
client since the client will have one relation to the placement and the
placement will have a one relation to the facility.
I do anticipate needing frequent reports that list clients per facility
so that would be an advantage to store the facility in the client.
Should I be creating a relationship between client and facility when the
real relationship is between client and placement and the other real
relationship is between placement and facility?
Craig