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