Thank you.....
In the end I went with:
Fact table (FK) to Group Table (PK) to bridge table (FK using the parent ID) to Dimension table (PK)
I just used an example (Healthcare) rather than using my actual business area.
For the parent key, I just set it against the most recent data item for this specific schema.
I do have a seperate dimension for my person details which is a one to one relationship.
Thats really useful information. That you so much. I have read that many people dont bother using foreign keys for their schemas and that seems like an easy way to do it (But a wrong way)
Thanks again
Debbie