DRW pulldowns and edit pages

M

Mike

On my edit page, I would like to have a pulldown instead
of a text field that is linked to the database return the
value of the database entry.

Example:

Client selects "retail" as the project type when filling
out a form (projType) in a DRW pulldown.

When editing a project, I would prefer a pulldown that
allows him to change the projtype from say "retail"
to "commercial".

next time he edits the project, "commercial" should be
selected in the pulldown.

help
 
M

Mike

Kathleen,

That's not what I am trying to do.

When editing records in DIW pages, I have a field
called "projType". When I select a project to edit,
the "projtype" field displays "retail" or "housing" in
the text field.

I have 6 project types to select from when creating the
project.

When I edit a project, I want a drop down list that
displays my current selection (say retail) instead of the
text field. I want to be able to select "housing" from
the list and update the record with that.

If I return later to that project, I would expect to
see "housing" in the pulldown (selected). If I choose, I
can select "commercial" and have the record update and
later reflect "commercial".

Does that make sense?

-M
 
T

Thomas A. Rowe

Not sure how you can do this if working directly with the FP database components, but if hand
coding, your would do it like this:

<select size="1" name="projType">
<option selected value="<%=fp_rs("projType")%>"><%=fp_rs("projType")%></option>
<option value="Retail">Retail</option>
<option value="Housing">Housing</option>
<option value="Commercial">Commercial</option>
</select>

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
M

Mike

Thomas,

Thanks for the help. I entered the code and the page
appears to update, but looking at the DB it did not
update the field.

Any ideas?

I had this working on a site a long time ago, but can't
seem to find the code for it.

-M
-----Original Message-----
Not sure how you can do this if working directly with
Click to expand...
the FP database components, but if hand
 
M

Mike

Thomas,

Thanks. I figured it out.

-M
-----Original Message-----
Not sure how you can do this if working directly with
Click to expand...
the FP database components, but if hand
 
Top