Relationships and Selected Records

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.

That depends on whether or not you have checked the Include Invisible Data option when setting up the relation.

Ahh, I had searched all over for a “Selected” option and managed to go right by “Invisible”.