0

Filter table data that is linked in another table

Well I have two tables as follows

1. Contact in which it has the following fields (a) Name, (b) Type

2. Prospective in which it has the following fields (a) Product (b) Price and a link field from Contact Table "Contact 1: Prospective N"

 

What i want is for the link to show only names with the Type "Customer" when i click the link, is that possible ? 

1 reply

null
    • Fred
    • 2 yrs ago
    • Reported - view

    You can put a constraint on reference fields.

     

    Edit the reference field then click on More options.

    Click on the box under Contraints

    Type in: b.Type = "Customer"

    Click on OK

     

    Since you have a reference field that links Contact to Prospective, Ninox treats the Prospective table as "a" and Contact as "b". That is why you use those letters.

     

    Let us know how it goes.

Login to reply

Content aside

  • 2 yrs agoLast active
  • 1Replies
  • 169Views