I have set up a value list that uses "values from field". But I do not want the list to include ALL the records in that table, but only records that have a status="Active". How can I filter out the inactive records?
Assuming you want to display the field cNameFull in your VL, create a calc field, type text, as
Status = "Active" ;
and use this calc field in your VL.
In the parent table, create a calculated text field with the calculation "Active". Make this field global so that it is the same for all records in the parent table.
Then use that field to create a relationship to the status of the other table.
In your value list set up, choose "related values only" instead of "show all records". To complete this, choose the parent table. That way the value list will find all records that have that "Active" status in the child table. Mine, in the picture, is looking for employees that fit a specific role. In the Houses table, I have a field called "Role_g" on which the user can choose "parent", "aide" and so forth. When the user chooses "parent", this value list will only show those employees with that role. The HOU__Houses to HOU__EMP_Employees relationship is HOU__Houses::Role_g = HOU_EMP__Employees::Role
Retrieving data ...