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.
Is the layout the same for each property record displayed on a given Property layout?
If so, your portal method should work. Since it didn't, you'll need to look at the relationship on which the portal is based and the options you specified in portal setup if you used a portal filter.