Forum Discussion

Qrew Member

3 years ago

Filtering a report link on 2 fields

Hi, I have created a many-to-many relationship table between 3 different tables and need to create a report link in one of the parent tables that will filter records based on matching 2 different set...

MarkShnier__You

Qrew Legend

No problem. Just make a formula text field on the asset table which concatenates the related contract and the related country

for example

list("-", totext([related country]), totext([related contract]))

then make the same field on the target table.

Then make a report link field that looks for a match on those two fields.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

OrlaO_Reilly

Qrew Member

3 years ago

Hi Mark,
You're a gem - this worked a charm and my report filtering on the concatenated field is pulling just the data I need!
Thank you so much!

------------------------------
Orla O'Reilly
------------------------------