Jump to content

Criteria for child records


susienray
 Share

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

Recommended Posts

  • Newbies

To find related records in a child file, I've been using the technique of putting multiple parent keys in a global field which has a relationship to the child, and then using GoToRelatedRecords. Works great but...how can I then further search the children? For example, by this method I can find all children of parents whose Active flag = Y but then what if I further want to only see those children whose phone = home? If I do a find of the children, I end up with all children whose phone = home, not just those children of active parents. This must be a common problem and I'm sure there's a technique. I just don't know it. Tanks.

Link to comment
Share on other sites

quote:

Originally posted by Susie:

To find related records in a child file, I've been using the technique of putting multiple parent keys in a global field which has a relationship to the child, and then using GoToRelatedRecords. Works great but...how can I then further search the children? For example, by this method I can find all children of parents whose Active flag = Y but then what if I further want to only see those children whose phone = home? If I do a find of the children, I end up with all children whose phone = home, not just those children of active parents. This must be a common problem and I'm sure there's a technique. I just don't know it. Tanks.

In the related file issue a search form in which you can enter all needed criteria then, via script, perform this search and you will have your results.

Obviously have some 'navigational trick' in order to come back to the calling form in the master db.

Regards

Link to comment
Share on other sites

This topic is 7373 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.