Need some help please.
Have two tables. Table 1: Gen Pop Evacuation Center Registration Table 2: Gen Pop Pet Registration
Table 2 contains an ID column that is Ref type back to Table 1.
I want to add a virtual column to Table 1 that will show the pet location from Table 2. But when I try the expression below it shows every pet location not just the location for that ID:
Gen Pop Pet Registration[Pet/Crate Location]
How do I filter it by registration ID?
I’m good with references from table 1 to table 2 [ID].[col] - but not the opposite direction.