I have played a bit with the Scripting block and I am amazed at its potential!
Though I am stuck following a recent idea to enhance our base capability.
We are managing real estate opportunities and we’d like to create a tool that matches all our client needs with our land portfolio characteristics.
Let me explain, I have a table for owners’ requests (CANDIDATES) and another for land characteristics (LAND). I have several other tables with the characteristics by type (identical to the owners’ requests) to identify possible matches between the two.
In my CANDIDATES table, I can look up all the LAND for each characteristic in different fields.
Now what I’d like is to produce a report or table identifying the unique lands which have all the characteristics of the owners’ requests and that for each Candidate.
Thanks a lot