Jump to content

Some simple find questions


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

Recommended Posts

  • Newbies

I see a function called Get(RecordID). Where can the result be used ? Can the Perform Find(restore) be used with dynamic criteria (i.e. a variable) or is it only for fixed criteria ?

I have tables A and B in a 1 to many relationship. After performing a find on A I FMP creates a found set of records from A. But how can I get the set of corresponding records in B? And how can I use that result later to reselect those records ? I'm hoping for a DBMS type method; I know I can always create a brute-force script.

Link to comment
Share on other sites

"I have tables A and B in a 1 to many relationship. After performing a find on A I FMP creates a found set of records from A. But how can I get the set of corresponding records in B?"

Take a look at the Go to Related Record (GTRR) script step, and the "match found set" option.

Link to comment
Share on other sites

  • Newbies

Thks. I've used GTRR but there are problems. GTRR makes me navigate to a new layout, but I'd like to have criteria and results in one view. The only object I know of to display multiple related records is a portal, but the portal has no such found set options. Using GTRR w/original layout (so I stay with criteria layout) doesn't work. Portal still shows records grouped by found set from base table. A layout in a layout would be nice here.

Link to comment
Share on other sites

This topic is 6093 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
×
×
  • Create New...

Important Information

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