Need some help please. Have two tables. Tabl...

[Tammi_Canelli]

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.