Hi, I need your help!

I have a DB with a Yes/No tick box as the approved dealer field in the USERS table and another table which holds their adverts.

I have set up and Admin area of my site where I have put a list of dealers that have registered, next to the dealer's name I have a radio button. What I’m wanting to do is when I click the radio button it ticks the tick box in the approved dealer field thus showing their adverts on the front page and removes the tick from the previous dealers tick box.

I can do this manually by going in to the DB and ticking the tick box but this is not very practical.

So if someone could tell me how to do this I would be most grateful.

In Access true (checked) is value -1 and false (un-checked) is value 0.

Now here's the interesting bit, SQL Server, also from M$, has a true value of 1 and a false setting of 0. The most confusing is that if you output a Access true value is that it results in TRUE on your page.

Now that we know this we can insert a radio button set (two buttons with same name) give one value of -1 and the other is value 0, then we add a server behavior dynamic form element -> Dynamic Radio Buttons, to which we apply a value equal of the recordset field which we bring up by pressing the Lightning Bolt and we select the recordset in question and the field holding the true / false info.

more in this article:
www.macromedia.com/support/ultradev/content/dynamic_checkboxes/dynamic_checkboxes08.html

Hope that helps you.

With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services