Are Relations in databases supposed to only work on selected records in the second database? I’ve found that it is necessary to select all for complete success.
In setting up the relations too, the Key Test is empty if no records that already match are selected in the second database.