I have a Bottled Water database with a Plants column and I have a Reporting database. I want to create a REF to the Plants column in the Reporting database. When I try to create a REF it only lets me choose from tables in that database. Is there a way to REF a table that’s in a different database?
A Ref value can only refer to a row, not to a whole column or to a particular column of a particular row.