Hi All:

this is what im trying to do. display a list with first name, last name, office and wheather they are in the office or out.

What i need help with is how do i set up a form in ud4 to list the names and such then the user can click if the person is in or out and update.. I am very new to ud and i dont understand the radio button functionality yet. also my db is set up with a field for in and one for out is that correct??

In a nutshell you need to create a recordset containing the dynamic data you want to use on the page.
Make a table and put the recordset items in there and then using the dmx server behaviour set that row to 'repeat region' for all items in the recordset - or just a finite number (but you would then need to also include recordset navigation - dmx can deal with that for you too)

That will give you your list with the names in, and do it for everyone in the recordset / table.

Put the radio button in, bind the primary key to it so each radio button has a unique id and will update the relevant record. Next you'll need to bind it to the data to get its dynamic value. Use the lightening bolt to get recordset data to populate it. You could also do this with just plain text and an IF ELSE statement rather than the radio button

Finally use the dmx update server behaviour to apply the changes to the database.

Sharing knowledge saves valuable time!

Simon

[DWMX 2004]|[SQL]|[ASP/VBScript]|[XP-Pro]