Populating a Table based on a field in another Table

Discussion created by rorytate on Mar 21, 2018
Latest reply on Mar 22, 2018 by philmodjunk


Pardon my ignorance, but i'm stuck on a problem in FMP 16 Advanced.


Let's say i have a Table where each record represents a widget. Some of my widgets in the Table are rejected while others are kept, so i have a Number field in the Table called 'Rejected' that contains either a one (if it's rejected) or a zero (if it's kept).


Is there a way to create a second related Table that only contains my non-rejected widgets? In other words, only containing records from the first Table where the 'Rejected' field contains a zero?