Jump to content

Can a parent also be a child?

This topic is 6162 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a link here to a screenshot of my relationships table :)Relationships Table. My question is this:

We work with families and generally we enter the parents as our primary contacts, which fall under family_id . Then, we can enter their children and the various info for each child through a portal to the youthserial_fk link.

Here is my problem. Every once in a while we have a youth whose parent is a primary contact, but who is also , as a youth, an independent client themselves - and I don't know how to create a relationship where both parent and youth can be seperate records under family_id, but then still allow access to the youth's information as a child record of the parent.

I know, why couldn't I be talking about apples and trees instead of actual families when we use parent and child for relationships. Sorry about that! I hope someone can understand what I'm getting at here despite the awkward vocabulary. Thanks in advance! Tia

Link to comment
Share on other sites

I cannot work out your relationships because I cannot see what the tables actually are.

However, you talk about a FamilyID so I assume you have a Family table, and so you must also have a Person table (since families are made up of people).

So for each family you associate multiple people and I guess you mark one as being the primary contact.

But I reckon this is actually a business process issue: when the youth becomes an independent client, should they get their own Family record? After all in tile they might have their own children attending. They could still be associated with their original family.

Link to comment
Share on other sites

This topic is 6162 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.