Argyle7 Posted May 22, 2002 Posted May 22, 2002 I am trying to show in a pop-up menu, the values of a certain field called "diagnosis" in the database so the user can do a search. Do I have to hard code it? I've tried the following code to see if I can get it to dynamically display all the different diagnosis fields in the database: <SELECT NAME="Diagnosis"> <OPTION VALUE="" SELECTED>All [FMP-option: Diagnosis] </SELECT> The above code is contained in a webpage called search.html which I am calling by pressing a button on a different webpage. Is the above code correct? Also, what should the button that calls it have in its code?
Garry Claridge Posted May 23, 2002 Posted May 23, 2002 [FMP-Option] is only used if the you have a FMP Value list applied to that field in the layout. Else, you would have to use the [FMP-Record] tag in conjunction with the [FMP-Field] tag. Check the 'CDML Reference' database for a full description. Hope this helps. Garry
Vaughan Posted May 23, 2002 Posted May 23, 2002 And to save you some time and trouble, related value lists (value lists based on a relationship) don't work at all over the web.
knussear Posted May 28, 2002 Posted May 28, 2002 I was able to do it by making a value list of the field contents (in this case the field Contractor has a value list named Contractor. The link to the format page is: <a href="http://hostnamehere/FMPro?-db=Project%20Database&-lay=WorkLayout&-format=vltest.html&-view">Value List test</a> and the body of the format page looks like this <body> <FORM ACTION=FMPro METHOD=POST> <INPUT TYPE=hidden NAME=-DB VALUE='Project Database'> <INPUT TYPE=hidden NAME=-Lay VALUE='WorkLayout'> <INPUT TYPE=hidden NAME="-Format" VALUE="record_detailproj.htm"> <INPUT TYPE=hidden NAME="-Error" VALUE="record_detail_error.htm"> <INPUT TYPE=hidden NAME="-recid" VALUE="[fmp-currentrecid]"><BR> <select name="Contractor"> [FMP-ValueList: Contractor, LIST=Contractor] <option value="Custom=[FMP-ValueListItem]">[FMP-ValueListItem] [/FMP-ValueList] </select> </form> </body>
Recommended Posts
This topic is 8284 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now