Reservations with waitlist

[tareyj8569]

Views: 9 Size: 57.2 KB">event1.zip
Hello all,

I have looked high and low for a template or example that shows a working waitlist but no luck.
If any one has an example to share I would appreciate it very much.

Currently I am trying to fiddle my way through it but not having much luck.
I Included what I have done so far, tblevents is the main form.
how it works is you set maxpeople and maxwait. if people signed up is below maxpeople sign up button shows once the number signed up equals maxpeople the sign up button goes away and a waitlist button shows up and any one who signs up it will mark them on the wait list. Also there is a datesignedup field that marks the date and time for the waitlist.

So now I'm stuck, how do I go about letting some one delete their request and if that opens a position than the database will grab the first person in line.
I did not set up their personal view where they delete because I already can do that just need to figure out how to auto fill from waitlist.

Hope I was able to explain enough.
also thanks for taking time to read

[orange]

Can you describe how this fits together? You have described (mostly) HOW you have done something, but it isn't clear (to me anyway) what the something is. In tblEvents you have a intMaxWait, what does that mean exactly.

Many problems with wait times involve queues where there are servers and customers. Customers arrive at certain time intervals and server can "serve" a customer at some rate. This is often a statistics problem (queuing theory). It isn't clear if that is what you are dealing with or not.

Good luck with your project

[tareyj8569]

Will try and explain better.
I have 3 tables.
tblPeople
PersonID
full name

tblevents
Eventdate
Maxpeople <max allowed to signup before wait list
maxwait <max people allowed to signup on the wait list

tblEvenReservations
Eventid <same id as the event from tblevent
personid<same id as from tblpeople
Datesignedup <date and time of person signing up
waitinglist <is person on wait list
I used a junction table.

when some one opens tblevents <form> it will show them the date and event.
When the person signs up it marks the date and time they do, If that event allows 2 people on maxpeople but only 1 signed up than the signup button will show else the wait list button will show. if they go to an event and people sign up is greater than maxpeople and the waitlist is greater than the maxwait than neither buttons show up and a text shows saying there is no opening and the wait list is full.

All that works.
I am trying to figure out is lets say an event allows 2 people to sign up and 2 people on the wait list.
Both are at 2 but some one on the reserve list canceled how can I make it automatically grab the person with the earlier signed up date on the wait list and mark them reserve.

I am thinking on the persons view an after update that will compare and grab the person with the lowest request date.
I just don't have a clue how to code something like that.

hope that was explained better, not the best at it.

[orange]

Just typing as I'm thinking:

If PersonSignedUp cancels
 remove that person
go to WaitList and select the person who has been waiting longest
add that Person to the SignedUpGroup and remove him from WaitList

other things to consider

A person wants to sign up
 if the NumberSignedUp < MaxToSignUp
    - yes then add person to signedUp----->exit
    - No  - it's equal so check the waitlist
        If NumberOnWaitList < MaxForWaitlist
           -yes then add the person to WaitList----> exit
           -no -it's equal so WaitList is full--sorry--->exit

[orange]

cross posted at http://www.utteraccess.com/forum/ind...ic=2033535&hl=

tareyj8569,

When you post the same question in multiple forums, please let readers know that you have done so.
It isn't wrong to cross post, but it is considered proper etiquette to inform readers.

See this for more info.

[tareyj8569]

Ahh k thanks for informing me, sorry about that. Will do that in the future.

[orange]

No problem. Denis (on UA) has provided a sample--very nice.

[tareyj8569]

Yes he did, Looks to point me in the right direction. If any one interested in the sample its located at the above link, for some reason cant link it from my phone.

Also thanks Orange for your time I do appreciate