Jump to content
Sign in to follow this  

Data from 2 Records on One Layout?

Recommended Posts

Is there a way in Filemaker Pro 11 to display data from two records that are from the same table on one layout?

I thought I could use a portal to display/print the second record's data, but when I try to set up the portal the current table (and all other tables in the database) are grayed out so cannot be selected. It has been a long time since I did more than just enter data in the database, so anything I knew about portals is apparently forgotten.

Here is what I am trying to do: The database contains 7,000+/- membership records. Some members are family members to one another. Each has his or her own membership record and membership number, so their records are all in the same table.

The family member gets a membership dues discount, and so some info from their record needs to be displayed/printed on the dues statement for the primary member. Is there a way to display data from two records that come from the same table on one layout?

Thank you in advance for any help.

By the way, in light of my obvious ignorance, can you suggest training suitable to a small business owner who uses simple Filemaker databases? Internet resources are always good, though I would travel to Portland, OR or Seattle, WA for good instruction.

Share this post

Link to post
Share on other sites

You can create another table occurrence of the table on the graph and key the relationship on whatever criteria you want to link the family members. Then you can use that table occurrence for the portal.

As for training, the best bet is to try and get with some of the local developers out there in one of their User group meetings. They have a pretty strong community in Portland as well as Seattle.

See here for contacts.


Share this post

Link to post
Share on other sites

Thank you for pointing me in the right direction!

I've made the table occurrence and the portal, and now I need to figure out how to have the family member's record display in that portal. I can't use the Membership Number as the matching related records or it just displays the same record's data; gotta find a way to make a portal including a searchable field that I hope will then display the family member's records. Back to the books!

Thanks for the User group recommendation; I will check them out.

Share this post

Link to post
Share on other sites

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

Sign in to follow this  


Important Information

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