Skip to main content
Question

Filtering a report link on 2 fields

  • November 9, 2022
  • 0 replies
  • 143 views
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 sets of fields in the child table.
Is this possible, and if so, how can this be done?
For context, I have a table of assets, a table of countries and a table of contracts as parent tables. The approvals table contains records of which person is approved to work on a contract in a certain country.
I am looking to pull a list of approvals onto the asset form which will only include approvals that match both the country the asset is linked to and the contract the asset is linked to. The report link currently will filter either on the related contract or the related country, but not on both.
Has anyone ever done something similar, or have any suggestions for how this can be achieved?
Thanks in advance!

------------------------------
Orla O'Reilly
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement