Need Help with get(recordnumber)

[Josh Meyer]

Hi, my name is Josh and I'm new to Filemaker. Could someone help me with this?

As a starter project I made an inventory list for tools. I have two related tables: tools and variants.

I want all my tools and their related variants in a report grouped by categories and subcategories. The categories are grouped by subsummaries. The subcategories however are displayed next to the tools. Therefore I always want to hide all subsummaries but the first. I was able to hide the subcategories with this:

let ( rn = get(recordnumber) ;
case ( rn > 1 ; variants::id = GetNthRecord ( variants::id ; rn - 1 ) )
)

However this hides only the subcategories on a product by product basis.

This will only display the very fist subcategory:

let ( rn = get(recordnumber) ;
case ( rn > 1 ; werkstatt::subcategories = GetNthRecord ( werkstatt::subcategories ; rn - 1 ) )
)

Can anyone help?

 

Thanks Josh

 

 

 

[comment]

I just answered this here:
https://community.filemaker.com/en/s/question/0D50H00007F4yiLSAR/am-i-missing-something-getrecordnumber-on-related-table