I have 2 tables: Properties and location. Each property belongs to a location hence we have location_id as our foreign key in the property table.
As you can see in the screenshots below, the property table view has a location ID. Instead of the ID, I
would like to display the fields present in the location table to make it easier for my agents to filter out properties in a certain city, area, or region
Required: on property table, I want to see the columns country code , city , area , and region.
Kindly advise how I can achieve this?