valuelist from "cat a" field

[concrete]

i have a file with 3 fields

id, name and category (can be A of :.

now i need a value list (to use in another file) with all the names with category set to "A"

pieter

[Lee Smith]

Lets call the two files A and B. The one with the three fields you have described will be File A for the moment.

Create a calculation field in each file A & B and name it something like ~Constant and have it equal to "1" (without quotes).

In File B, create a relationship to File A using the ~Constant field.

In File B, Define Value List choose the second option (use a value in a Field) and use the relationship you just created.

Attach the value list in the layout mode to the field of your choice.

HTH

Lee

[concrete]

thx lee,

but i think you did misunderstand me

in file A (with the 3 fields id, name, category) i have tis

1, name 1, cat a

2, name 2, cat a

3, name 3, cat b

4, name 4, cat b

5, name 5, cat a

know my value list should be all the names with the category "cat a"

name 1

name 2

name 5

i hope this is a bit less confusing

pieter

[Lee Smith]

Sorry, should not try to answer question before first cup of coffee takes affect.

The attachment explains it better than I can verbally.

Lee

Example CVL.zip

[concrete]

thx lee

addition question

could i create a value list with first all the "cat a" names followed by all the "cat b" names

[Lee Smith]

Hi Concrete,

I made the field in File b a global. Change it to b and see what happens.

Lee

[concrete]

hi lee

that i figured out

but i was wondering if i could get them bouth in one list, sorted by category

I tried the sort second field thing in the value list, but then I only get 2 values (one for cat a and one for cat :

[Pupiweb]

That's expected behaviour

You can work around that making a calc field = category & field and using that as second field in the value list

It works but makes things quite kludgy ...

I'd consider alternatives like a portal or making the file act as a "floating palette" .. bit of work, great effect, great flexibility

[Lee Smith]

Hi Giuseppe,

"floating palette" - do you have a sample of this on your site?

TIA

Lee

[Pupiweb]

Hi Lee

You can see an example - for completely different purposes - here:

http://www.buliga.it/TipFiles/SFISearch.sit

http://www.buliga.it/TipFiles/SFISearch.zip

[Lee Smith]

Hi Giuseppe,

I downloaded those files when you first intoduced them, obviously to see how a SFI worked. Didn't connect the "floating palette" with it.

Sorry,

Lee