Client vs parent vs carer

[Glenda]

HI

I have a client (a child) who has parents and or carers and then they (years down the track) become parents to another client. I also have doctors, psychologits, liason staff etc.

Do I represent all these people as 1 table (person) with a relationship table that relates client to person2, with the type of relationship (eg birth parent, carer etc), or should all these groups be separate tables?

[musixer]

Could you explain what you are going to do with those relationships...?

[mr_vodka]

These posts may give you some ideas.

Genealogy

Genealogy 2

[Glenda]

This database really isn't chasing genealogy as such. the clients are suspected abuse cases and therefore have parents and carers. Most times they get referred again but on the next visit the carers and the parents partners may all have changed. I coudl well keep the doctors and psychologists seperate but who is to say they may not end up as one of the parents or carers.

I will look closely at the genealogy link and text john, but the genealogy2 download is not working at the moment.

[comment]

I'd say one People table and another table for links is the right idea.