DRW pulldowns and edit pages

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
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
 
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.
==============================================
 
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
 
Back
Top