Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Find by relationship not working as in FM5


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

Recommended Posts

Posted

My plan is to have the user view a list layout showing various reports and their contents and other significant data. Some reports have similar types of data from different dates and comparing that data is important. One of the buttons in the header is "Same Client & Report" which would (using setfield) copy the client ID and Report items fields into corresponding globals and the command show related records. The result would be a list of all records having same item and client id as the initial report viewed. This worked great in FM5 but not FM7. What am I doing wrong.

Find would not work because reports can have multiple topics A,B or B,C, or A,D. If my initial report is A,B than I want to list all reports containing either A or B. a relationship is the perfect tool as using the paragraph mark between topics gets the appropriate result. I don't want to build a portal and make it look like my list layout if I don't have to.

My table is Reports. My fields are ClientID, Topic (which is states what the report contains in 1 or 2 standardized words, and if more than one topic is present in the report the topics listed will be separated by a paragraph mark), gID a global field, and gTopic which is another global field.

My relationship ReportsByTopic is ClientID to gID and Topic to gTopic.

The layout is formated to reports.

My script is

Setfield gID: ClientID,

Set field gTopic; Topic

Show related records ReportsByTopic using current layout

I miss the intuitiveness of FM5 but the features of FM7 are can't be beat.

Any help is appreciated, as always.

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