They are related, one table contains property data such as address, images, and such that I only need a single record for. The other table contains unit data, like how many 1 bedrooms, 2 bedrooms, what the floorplan name is, etc. that exists in a property, so there’s multiple records in this table for each property. They can be joined via the Property Name at the moment.
I already “join” them myself within the cell of the RG through the common Property Name but each field that comes from the second table is a “Search for” result from the second table. In the image below it’s the bottom box of numbers and that’s just one cell out of many that will be displayed, including weighted average calculations at the bottom that each appear to require 3 searches for just one result. That’s 19 additional searches just for one cell, in addition to each row in that bottom group also having multiple criteria (property name and unit type).
The top portion, the address, pictures, etc. comes from the first table and have no additional criteria as it comes from the RG data source so only one search per cell.
Forum
Academy
Marketplace
Showcase
Pricing
Features
