Reserve selections.

[MattCrawford]

I have a database of racks and servers. To make this easy and short,
it's an inventory system where we assign a server to a rack. is there
a way to develop a form that reserves racks when they are assigned so
no other server can be assigned to that rack. I guess the psudo
operation is as follows:

Form to enter new server, type in or select from dropdown the rack unit
and number.

create record.

Next person, creates new server, but when they go to put in the rack
unit info they dont see the one already taken, and cant type it in
manually, untill you remove the previous server using a deletion form.

I guess the rack table should have a check mark for if it's filled or
not, then the form checks against that to display only the ones not
checked. And the delete server form, deletes the server record and
unchecks the box in the rack unit table.

Make sense or should I draw it out more.

 

[MattCrawford]

Alright... it's going to be a bit more complicated then I had thought.
I'm going to develop a power point presentation of it. basically each
server also has a height, and takes up 1-15 units on each rack. Each
rack has 42 units, so i'll need 42 check boxes per record of rack, and
the form would have to mathmatically figure out which checks to place
based on starting unit number and height.

Also I wish to have a visual representation of this, I'm familiar with
asp somewhat and graphic arts, so this should not be a problem. That
way whomever is entering the rack, will see what is empty or not and
will not choose already filled location for whatever rack they wish to
put it in.

<breathes>