Compare two views, to find an offer to match for a demand

Compare two views, to find an offer to match for a demand

Hey, my name is Jo and I am from hamburg, germany. Thats my first topic in this forum  ...

At this point I am trying to create a database with zoho creator. I have created 3 Forms:

1. Offers
2. Inventory
3. Demand

with the same attributes and the current views. 

BUT: I want to create a View (or Report? ), which find the best "offer" (offers plus inventory!) to match for a demand and propose this one / show it. 

I would say, the program has to compare attribut per attribut and try to find  accordances --> the two entries with the most coincidences must be displayed...

If anybody have an idea to fix my problem / solve my question i would be very very  appreciative!  

Thank you very much in advance for your answer!