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...
Forum Discussion
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
------------------------------
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
------------------------------
- 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
------------------------------
