Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 8284 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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?

Posted

[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

Posted

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.

Posted

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>

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.