thollowood Posted August 7, 2007 Share Posted August 7, 2007 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 More sharing options...
Vaughan Posted August 7, 2007 Share Posted August 7, 2007 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 More sharing options...
Phillip Holmes Posted August 10, 2007 Share Posted August 10, 2007 thollowood I have a solution for you. It is the only way I know of to over come the proble you have. Take a look at the attached FM DB. Regards Phillip TestDB.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6239 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 accountSign in
Already have an account? Sign in here.
Sign In Now