group database

[concrete]

I have now a database of persons (who will go on our skitrip)

Now i need to group those persons in appartments of 4,5,6

each type of apparment is limited, and i don't have any spear beds..

This is going to be a big puzzle (because friends want to sleep together,...)

has anyone an id how to tackle this?

I think i need a database with records that contain 6 fields, each one with a dropdown to choose a name from the person database. The problem is, I don't want to be able to select the same person twice

and I want to be sure i've placed everybody.

finaly i have to take into account my number of appartments of each type.

I hope this is understandable...

thx concrete

[LiveOak]

My first option would be to somehow get out of doing this job! You'll never make everyone happy.

As to the simpler part of the problem. 1) a file of Persons with one record per person and 2) a file of Apartments with one record per apartment. I would not use six fields in the apartment file. Create two relationships from Apartments to Persons. The first relationship would show all unassigned records. The second relationship would be by apartment number (could be just record serial number). The persons assigned to an apartment would be displayed in a portal. When assigned they would disappear from the "available" portal and appear in the portal of people assigned to that apartment.

-bd

[Ugo DI LUCA]

Hi Concrete

because friends want to sleep together,

Start with this.

in appartments of 4,5,6

each type of apparment is limited

Proceed with that.

and end doing this manually if the number of attendees are less than 16 persons (4+5+6 = 15)

[concrete]

Proceed with that.

and end doing this manually if the number of attendees are less than 16 persons (4+5+6 = 15)

I'm doing this for 120 people -(

I have been doing this manualy for several years, and I end up with a mess every year...

The problem is that you have to be able to keep moving people around untill it all fits...

That's why I'm trying to set this up...