Appointment system

Requirement

Our company organize a trade exhibition based on pre-scheduled appointments between sellers (those who pay to have a stand and meet buyers) and buyers (those who come to the event on a free of charge basis and visit sellers on their stand).

The success of our show is based on the successful delivery of perfectly matched appointments between buyers and sellers and our capacity to serve them with 12 appointments per day at fixed time over 3 days.

The show will gather around 400 exhibitors and 440 buyers.

The appointments process works as follows:

1. Buyers and sellers go online and register the 65 companies that they would most likely like to meet.
2. Each buyers and sellers can see in real time who has chosen to see them and each of them will more or less try to mirror the other party preference.
3. When it is done our system should try to create appointments into a diary table for each of the participants bearing in mind that the system should:
• First: Give preferences to perfect matching
• Second: Give preference to buyers
• Third: Give preferences to sellers with the best possible match.

We are basically looking for developers able to provide us with the right database architecture and SQL formula in order to make this happen in File maker pro.

Is anyone interested by this challenge?

Kind regards

Serge Dive