I am a Retail Leasing Broker with a team. One building might have many listings in it, or many past transactions that we need to keep comp details for.
I have a module Properties and would like to add a 6 to 8 field section with listing data... each time new listing information is required. Same thing with past transactions for comp/valuation purposes. One building can have a tremendous amount of data to track associated with it.
Another example is multiple locations for a CVS when we don't have a relationship yet. In the Leads module, I would like to be able to aggregate all the CVS locations in NYC onto one Lead since in the end it will be one Account with one Contact. Generate a Rule that says "Add Location" and another section appears... even if it is the 15th location and we need a 16th.
The information is well beyond the single line that might go in a subform endlessly repeating like inventory.
There seems to be a long way to do this... anticipate the maximum possible number of Sections (Say 20) and hide them. Then create rules that reveal each Section in response to input... but there must be a better way. I hope.
Thank you in advance for your time and attention.