Seating Arrangement

[Guest]

Hello,

Does anybody know of a way to assign (for example) 50 couples attending an
event to 10 Tables with 10 chairs each?
There is other conditions to it, but for now I just want a way to do it!

Thank you
Muneer

 

[Guest]

I think we need to have more information than this. Do you want to know how
to design the tables, or how to design the forms that will accept the
criteria, or both or are you asking something else entirely?

You could design a few tables like this and go from there

table inventory could have two fields (ID, and Description)
1 - Table 1 is next to kitchen
2 - Table 2 is next to entry
3 - Table 3 is in the worst possible place
4 - Table 4 is in the best possible place
etc...

a couples table (but will anyone coming not be part of a couple???) (ID -
Description)

1 - Mr. and Mrs. Smith
2 - Mr. and Mrs. Jones
3 - Mr. and Mrs. WTHC
etc...

Then another table could bring these two tables together

tableID, coupleID
4 - 1
3 - 3
4 - 2

This would place the smith's and jones' at the best possible table and the
WTHCs and the worst possible table.

 

[Joseph Meehan]

Hello,

Does anybody know of a way to assign (for example) 50 couples
attending an event to 10 Tables with 10 chairs each?
There is other conditions to it, but for now I just want a way to do
it!

Thank you
Muneer

I doubt if you need Microsoft Access (the database program that is part
of Microsoft Office Professional) to do the assigning.

If you do want to use Access, you will need to figure out what rules you
want to use when assigning tables. Random or some sort of selection process
or some other ordering (seniority etc.)

 

[Van T. Dinh]

Stick 100 name labels onto 100 chairs (1 label to each chair, of course)?

<g>

Van T. Dinh

 

[Douglas J Steele]

Sticky side up or down? <g>

 

[Guest]

Thank you all for your reply

Suzy.. This is a small part of the application that I'm working on. I do
have a table with some of the following info:

tblMain
RegistrationNo
LastName
FirstName
NumberOfAttendants
City
_
_

I will need something smilar to your table "table inventory", because I have
two events where I don't want to seat the people in the first event at the
same place for the other day event, but let's not worry about this at the
moment!

I was thinking of something like this: for example, go through "tblMain" and
take the member with the RegistrationNo "3" and assign him (if the attendants
number is 1) or them (if the attendants number is 2), to TABLE number 1. Then
take the next "RegistrationNo" from "tblMain" and assign the same TABLE to
him or them, until TABLE 1 is full (10 chairs occupied), then go on with the
next TABLE.

RegistrationNo LastNeme NumberOfAttendants TABLE
3 Smith 2
1
56 Jones 1
1
-
-
After we have 10 persons per TABLE "1", proceed to TABLE "2".
I also have a text control "Event1tableNo" on the form "frmRegistration"
bound to an empty field in the table "tblMain". When the a specific button on
the "frmRegistration" is clicked, all those fields will be filled out. To do
that, I need to know whether I need another table like yours, and how to link
all these together, and what is the code that I have to use?

Joseph.. I hope I explained some of your concerns above. I think we should
pick the members randomly and assign them into TABLES, in this way we will
eleminate the chance of sitting two members from the same city together. The
reason for that is to get them to know each other.

I hope it a little clearer now. Please let me know if you need more
explanation.

Thank you
Muneer