I have 3 different tables:
- prospects (looking for a place)
- Landlords (renting a place)
- Matching table
On the 1 and 2nd table, I have a column named “type of place” that is a single select option.
People can then fill “House” or “flat” or “shop” for example.
I would like on my 3rd table to be able to indicate in a column if there is a match between the answer of a prospect on table one column “type of place” and a landlord table 2 column “type of place”. I will then have a column : “Name of prospect” + a column “Name of landlord” + a column “Matching place” and the name of the matching criteria (eg: house).
Someone knows how to do that? :slightly_smiling_face:
Thanks a lot!