Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Show related record in portal

Show related record in portal

Show related record in portal

I have two tables, a relationship and a layout....... and an impression of the keyboard in my forehead.

Table1: ganderProducts
  Field: sGanderProduct  (text values like "V/V", "SI" and "Other Products")

Table2: clientIntake
   Field: sProdDiscussed  (return delimited list of values from 'sGanderProduct')
   Field: sOtherProducts  (freeform text)
   Field: calcShowOtherProds == Case(PatternCount( ganderProducts::sGanderProduct; "Other") > 0 ; sOtherProducts ; "")

Relationship: From clientIntake to ganderProducts
     sProdDiscussed   =  sGanderProduct

Layout: ReportByProduct
   Showing records from 'ganderProducts'
   LeadingSubSummary: sGanderProduct when sorted by sGanderProduct

   Portal: ::calcShowOtherProds  inside

What I WANT To Happen: When the Layout 'ReportByProduct' is shown in Preview mode, the field '::calcShowOtherProds' is empty. When the user flips to the page where 'sGanderProduct' is "Other Products" I want the field '::calcShowOtherProds' to show the value for the field 'sOtherProducts' for each row in the Portal.

I have tried multiple permutations of putting the calculated field in the clientIntake table and in the ganderProducts table. I can get it to work.... kind of. If I can get the field to show, the values shown are all the same.

Can someone help me?

I am running FM 8.5 Advanced on a Mac running 10.4.9.

Thank you for your help,


RE: Show related record in portal

Let me put it a simpler way.

I have a related field within a portal on a report page that I only want to show if the "sort by" field in the Leading Sub-Summary has a certain value.

I have found that looking at things from different angles sometimes produces different solutions. Unfortunately, this different angle didn't bring a correct solution to my mind.

How about yours?

Thank you for your help,

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close