Jump to content

Probably VERY Simple


TonyHiggins
 Share

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

Recommended Posts

  • Newbies

Okay. So, the solution to my problem is probably very simple, but I can not figure it out.

I am working with the sample Contacts solution that comes with FMP8. I want to be able to track families with this database. Thus, I want to be able to add one or more "family members" (i.e. Spouse, Child) to each record.

Right now, I have each individual (Parents and Children) entered as individual records, with individual Contact IDs (assigned by the database). I do not know how to assign a "Family ID," and make the database work so that:

1. Instead of entering each individual as a separate record, I start by entering the "Head of Household"

2. Then, I enter other family members from a "Family View"

3. But still have a "Main View" that shows everyone that is in the database, regardless of how they are classified.

I hope this was clear, and I would appreciate any help possible. Thank you.

Link to comment
Share on other sites

Here's an example file that illustrates one way to do this. Basically, you create a Family_ID field that links together all records with the same value in that field. If a record is created from scratch, the Family_ID field is set to the same value as the Contact_ID. Any contacts created via the relationship displayed in the Family portal (by adding contacts to the last row of the portal) will have the same Family_ID as the records from which they were created.

Contact_Management.fp7.zip

Link to comment
Share on other sites

  • Newbies

Reed,

Thank you very much. This is exactly what I'm looking for. I'm going to try and figure out how to "copy" what you've done, and work it into the file I'm using. If you have any suggestions, I would love to hear them. Otherwise, I think I'm good.

Again, thanks--and blessings,

Tony.

Link to comment
Share on other sites

This topic is 5733 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
 Share

×
×
  • Create New...

Important Information

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