Jump to content

Value lists from a Relational database


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

Recommended Posts

So I feel I have copied almost all your solutions i could find and there is still no information coming up in the field. This is what I have.

ColorSelection: <select name ="ColorSelection" size=4>

[FMP-ValueList: ColorSelection , New Value List]

<option> [FMP-ValueListItem]

[FMP-ValueList]

</select>

(New Value List)- value list name not fancy but I am just getting working on it working

So let see, do I need to tell it that it is actually coming from 2 values of another database if so I haven't found that info out here and was hoping one of you all knows???

Link to comment
Share on other sites

This probably won't work for your solution, but i will throw it in here just in case you might be able to do something with it. This is how i create a relational valuelist on the web.

code:


<select size="18" name="select">

[FMP-portal:relationshipname]

<option value="[FMP-field:relationshipname::fieldname] ">[FMP-field:relationshipname::fieldname]

[/FMP-portal]

</select>


Now i will be the first to admit that this is not a perfect solution, but in alot of cases it has worked well for me. The biggest problems you will have are only being able to pull a value list from one field. And of course your value list is going to show 1 value for each record, even if some records have have the same value in that field (which is why this may not work for your solution, it may make the valuelist to long for the user to work with) but in some solutions it does work. But i thought i would throw it out there just in case you might be able to do something with it.

Link to comment
Share on other sites

Ok so I am sort of there.

I did a portal to a new database, with only color item number and serials creating the value list with a preset amount of colors, 5.

ex.

value option="[FMP-field: relational::serialA] display= [FMP-field: relational::colorA]

value option="[FMP-field: relational::serialB] display= [FMP-field: relational::colorC]value option="[FMP-field: relational::serialB] display= [FMP-field: relational::colorC]

etc.

IT works fine but 2 porblems

A. shows blank areas when there is no information to be placed in it

B. the next database will have options from 3 colors to 30 resulting in a messing outlook.

Any Ideas

Thanxs

Soup

Link to comment
Share on other sites

  • 3 weeks later...
  • 2 weeks later...

This topic is 8335 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.