I'm prototyping a HOA building tracking solution building projects and am trying to link an Address field from one table in another table. Specifically, I have Properties table with addresses (and other information) of all properties. I want to link the Address field in the Properties table to the Current Projects so we can create a Map View of current projects. I can get the overall Property row but can't seem to link the specific Address field to create the Map view in the Current Projects table.
Any ideas?