Dropdown Box (CFSelect Problem)

[Duncanmcl]

I created a CFM using CFSelect against an Access DB lookup table (State). I'm trying to use a lookup control on another CFM Form and store the selected entry...and/or display the current value) My CFSelect works, how do I relate its values to the data being displayed on the other form. Example on a people form, the state field is replaced by the CFM state lookup using CFInclude? All the examples just illustrate the lookup process...they don't incorporate it within another process!

Thanks in advance.......Jim

 

[iza]

-> this is a coldfusion question that should go i nthe coldfusion forum ...
-> your question is not very clear ...
* is your problem "how to display the value" ? just do that then :
<select>
<cfoutput query=&quot;your cf select&quot;>
<option value=#the value#>#the value#</option>
</cfoutput>
</select>
* is your problem &quot;how to populate a select field from another&quot; ? then go to the jscript forum and there's a faq abot this

 

[iza]

i'm sorry i didn't even spotted i was in the cf forum !! sorry

 

[Duncanmcl]

The CFSelect work by itself bring back table values for selection. I'm trying to use this lookup within another template (ie people.cfm) on the state field to both display the current value (people.state)and allow user to view/select other values from this lookup CFSelect. So..again...how do I integrate state.cfm within people.cfm.....or do I just create one CFSelect within people.cfm??

Hope this is clearer!