Creating loops is not a very good idea. You'll get loosely coupled tables and those can give unpredictable, inconsistent and plain wrong results. You could try to create a link table that stores the relationships between the objects. See this document for an example.
I think the table relationships in your QV document might be wrong. I would assume that the link between leases and property would be a direct one, not via the areas table. If there exists a direct link between the propery and the leases table then I would join these tables on this relationship and remove the relationship between the property and the area's table. For the Area's table you could if it is only one value us an applymap to attach the correct column onto the leases table. If not just keep the existing table joined as it is.