Value list within a portal

[buildude]

Hello, I'm scracthing my head trying to figure out how to create a value list within a portal that will display values based on a second value list within the same portal.

Any ideas?

Thanks for your help, Peter [color:"black"]

[falkaholic]

In the parent file, make a new value list. In the options for it, click the "Use Values Freom Field" option and choose the field in the portal that you wish to list all the values from.

Then choose that value listin the Field Format options.

[Ugo DI LUCA]

Have a look at Djogi sample for Multikeys in the Sample section. I loved it and use it everyday to filter my product file.

[buildude]

Erick, Thanks for your interest...... I'm afraid that it might be a bit more complicated than I first made out. The parent File (Assemblies) contains the portal (Line Items File).

The value list (Category) within the portal, is based on values from another file (Materials). When I select a category from the value list presented by the field Category in the portal,

I hope to be presented with a managable list, pertinent to the category I've selected, upon entering the Item Description field (also within the portal and part of the active record). My desire is to do all the data entry from within the portal.

Best I can tell, I need to find a way to grab the value from the Category field that is within the portal row I'm working on, place it in a Variables field and then base a relationship for the Item Description field on the entry in the variables field.

Hope this makes senes, thanks, Peter

[Razumovsky]

you are looking for a conditional value list through a related file- I scratched my head for a while about this as well. Good thing that many other people have "invented the wheel" before us.

Ugo is right- check out the multi key sample file- this is what you need. Basic idea is that you create the list in the line items file. this list is made of values from a field in the material file, but related through a multi key. you then create a list in your assemblies file and select "use value list from another file." The value list you use would be the one you had just created in your line items file (related thru multikey to fields in materials file).

the multi key is an identical calc field in both line items and materials file.

The calc is something like:

category&"

[buildude]

Just wanted to say thanks for the input, I'm still digesting all that I've found around here. It certainly helped to know what to look for. Thanks Ugo and HTH!!! All the best in the new year.

[buildude]

Just an addendum to my plight: As it turned out, I did need a calculated key (multi key), in that I wanted to make selections from multiple value lists within the portal in order that I see only the values related to those choices. However, the real problem I was having was with the definition of the relationship. This is what I learned:

If the value list is within a portal, and the list doesn

[awayand]

Razumovski,

I cannot find the "eloquent" example you are describing. Would you mind helping me find it? I searched *everywhere*. This is driving me nuts. What exactly is a multikey? Thanks in advance for your help!