How to display tenants of shared apartment in layout?
I've set up a database for managing shared apartments. Two tables are used: one for properties, and one for tenants. Also have a layout for properties, and a layout for tenants.
In the tenant layout, I was able to set up a pop-up menu field that lets me select which property the tenant is renting.
In the property layout, I'd like to see the names of tenants who are renting that property (each property may have multiple tenants), but I can't quite figure out how to do that.
I used the Portal tool to draw a box and set it to show related records from the tenants table, and set the field in that box to show the tenant's name. But I just end up with an empty box.
Any advice? Thanks in advance.