I have one tabled named “customers” and another name “properties”. One customer can be related to multiply properties.
In another table called “Leads” I have a linked field named “customer” where I select the correct customer. I’d like to have another field called “address” where I’d be able to link to the “properties” table but it would ONLY show properties related to the Customer selected. Is that possible?