Checking fully booked on form load

Hi all,

I have a system I have built that allows people to book on an adaptive form based on the company I want them to use.

This is just piped into the end of the URL and then they fill the form out filtered on that. They have weekly options too so they can chose an option for up to 6 weeks based on the company.

I have built some code in that looks at the amount of bookings on that form as they chose the lookup [Event] and then checks that against the allocation I have given them. This works great and if the allocation is less than or equal to the amount booked it updates the record to say that it is now fully booked, emails the company to say they are fully booked and removes it from the lookup based on a filter for anyone else using the form.

What I want to achieve however is that when the form loads, with the company details, that it can check all of the bookings for all of the offers from the company. And any that are less than their allocation to untick the fact that they are fully booked. Therefore reinstating them in the lookup.

This is because I have a login area for the company where they can remove any bookings they want. Currently they have to inform me so I can check that they have some spaces available and then untick that they are fully booked.

Each of the offers are within Event 1, Event 2... Event 6 but are tied to these by weeks. Don't know whether that helps if I'm honest ha!

I'm just looking for some direction as whatever I'm trying I seem to keep falling down on.

Cheers,

Paul