Dear Helpers,

I want to create a user registration form for a meeting with several time slots. One time slot could only allow for 4 users. Ideally as soon as the time slot is full with 4 users, users wouldn't see the time slot as one of the choices when they register.
So I created two tables: timeSlot table and user table
timeSlot table: timeslot ID, timeslot description, and a control for number of users.
User table: userID, userName, timeslotID

The registration form itself contains two fields, user name, and time slot which is dynamically populated from the TimeSlot table when control < 4.

My question is: how does the form update the form timeslot table and user table at the same time? Now when the form is sent, the user table is updated(User name and timeslotID). I also want the control to be increased by 1 at the same time.

Any advice would be appreciated!

Cinderella

Hi guys, I solved the problem myself. It's so easy actually. I used two recordsets to retrieve and update data. Here is my code in case somebody is interested. The OC_fair table is the table for timeSlots and OC_fair_staff is the table for users. This is a simple form but very useful for inside company trainings, meetings, ...

<%
staff=Trim(Request.Form("staff"))
catID=Trim(Request.Form("catID"))

set rs=server.createobject("adodb.recordset")
sql="select * from OC_fair_staff where (staffID is null)"
rs.open sql,conn,1,3

rs.addnew
rs("staff")=staff
rs("catID")=catID
rs.update

set rs1=server.createobject("adodb.recordset")
sql1="select control from OC_fair where catID ='"&catID&"'"
rs1.open sql1,conn,1,3
control=rs1("control")+1
rs1("control")=control
rs1.update

rs.close
set rs=nothing

rs1.close
set rs1=nothing
conn.close
set conn=nothing
 %>