** Remove the "simple_" to reply to me directly

Sample page available here that show what my challenge
is: http://www.theransoms.com/tpsa/links/admin.asp

Click update to open an individual record in update
form. This works fine, get all the info i should.
Problem though is that i cannot find a way to update the
Category field (left is from existing record - right is
dropdown of all categories available which are in
different table)if i want to change to new category i
would have to submit from drop down list (this is how it
is at the moment) but what if i do not weant to change
category only other fields?

Possible solutions i see are 1) make the left category
field into a dynamic list from other table that knows
which entry to start on i.e. the existing category or 2)
get the drop down list to automatically start on the same
item as the existing record then if it changes it gets
written to the table correctly, if not it is the same.

Any ideas/pointers/advice much appreciated.

Thanks to www.sitebuilder.ws for the easy to follow
DRW/ASP/FP Tutorials

Simon

Forgot to mention the Visible field: I am having issues
with True/False 1/0 when updating the table. Can anyone
point me to some good material on how to get these type
of issues resolved.

Thanks

Simon
>-----Original Message-----
>** Remove the "simple_" to reply to me directly
>
>Sample page available here that show what my challenge
>is: http://www.theransoms.com/tpsa/links/admin.asp
>
>Click update to open an individual record in update
>form. This works fine, get all the info i should.
>Problem though is that i cannot find a way to update the
>Category field (left is from existing record - right is
>dropdown of all categories available which are in
>different table)if i want to change to new category i
>would have to submit from drop down list (this is how it
>is at the moment) but what if i do not weant to change
>category only other fields?
>
>Possible solutions i see are 1) make the left category
>field into a dynamic list from other table that knows
>which entry to start on i.e. the existing category or 2)
>get the drop down list to automatically start on the
same
>item as the existing record then if it changes it gets
>written to the table correctly, if not it is the same.
>
>Any ideas/pointers/advice much appreciated.
>
>Thanks to www.sitebuilder.ws for the easy to follow
>DRW/ASP/FP Tutorials
>
>Simon
>.
>