Value lists from a Relational database

[Soup]

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???

[Soup]

Oh ps. the values are from a relational database pulling from 2 fields that have the realtion agreed??

[Vaughan]

Relational vaule list don't work over the web.

[Soup]

Thanks I might have thought that but any way needed to know for sure

Thanks

[elvis_impersonating_penguin]

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.

[Soup]

Thanks that was my next idea run it through the portal thingie, thanks and I will see in a bit. But regardless, thanks anything is better than 12 hours of hit and miss

Thanxs

[Soup]

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

[Tyfud]

Check this Article out from FileMaker:

TI article 105336

It is an article that details how to get a related value list to work by using a portal tag around the [FMP-Option] tag. This is very useful.

[andershultdin]

This is done with a simple INLINE ... The valuelist is updated with -view command. I have tryed with the Portal Tags but it doesn