Jump to content
Sign in to follow this  

Return Unique Set

Recommended Posts

I have two files/databases/tables what have a parent and child relation. I want to search for parents that have children containing some characteristic. The result set that I want back is only those parents that have these childern.

For example:

Find all parents that have girls.

Although there may be several parents that have more than one girl, I only want to return that parents record once along with all other parents that have girls too. I have tried several approaches, the most recent being the use of "Go To Related Record" then execution of an external script in the Parent file which simply goes to a list type layout and goes into browse mode.

This is returning the first parent, and only one record. I am hoping that I can return all of the parents that meet the search criteria.

Any suggestions?


Share this post

Link to post
Share on other sites

I can think of a couple of options:

1. You can search in a portal. If you are in the Parents file, you can search for "girl" in a field that's in a portal to Children.

2. You could do your search in the Children file, then go to a Layout with just a UniqueID field and Copy All Records. Paste into a global text field. Then go to Related(Show only related) via a relationship of theGlobal to ParentUniqueID.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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