There are 6 records in the table. Hence, you see 6 records.
A TO is not a view. It still contains the same number of records regardless. If you want to see only records that have a match in the parent table, perform a Find.
1 of 1 people found this helpful
Note that if you put a portal on the parent table (in this case, "table"), you will see only the related records. This gives you another way to see only the matching records. The Go to Related Record script step (FileMaker Pro 15 Help) can help, as well.