Hello,

I am trying to create a dynamic field insert with Dreamweaver. I want the page to be able to insert the submitted data (only one string) into one of two fields in the database (depending on a form variable).

At the moment, I am trying to modift the following insert record behaviour:

If (CStr(Request("MM_update") = "save" And CStr(Request("MM_recordId") <> "" Then

MM_editConnection = MM_connMembers_STRING
MM_editTable = "members"
MM_editColumn = "memberID"
MM_recordId = "" + Request.Form("MM_recordId" + ""
MM_editRedirectUrl = "create_list2.asp"
MM_fieldsStr = "list_items|value"
MM_columnsStr = "list1|',none,''"

I am trying to make the "list1" above dynamic so it can be list1 or list2 depending on the form variable passed.

Anyone with any ideas.

Cheers,
Jamie