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 ? 



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.