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?