Dynamic Value List for Dynamic portal field

[xtrim]

Hi

I tried to make dynamic Value lists to each dynamic field in a portal,

meaning - if I change a the field in a column, then I get a different VL on that field.

I played with it, and I can't index the field that stored the VL, thus I can't make it a VL...

( I don't want to use "getfield(field)" , because it wont change unless record is updated...)

any suggestion?

[Here is a link to a test file]

[Søren Dyhr]

if I change a the field in a column, then I get a different VL on that field.

Do you mean the field inside the portal have a valuelist attached as well. So if a coloumn is chosen to show colours should the valuelist change to relevant stuff - in this case a choise of colours???

I need to know if it's the desire, having a hunch it has to do with this issue: http://www.filemaker.com/downloads/pdf/techbrief_fm7_foundations.pdf page 34 that gets almost incomprehensional when writing this:

The following rule is used to determine what record (and thus table) to use as the starting point for referencing fields in the context of a portal:

If the first relationship in the path used to get from the portal record

[xtrim]

Do you mean the field inside the portal have a valuelist attached as well

Sort of. A dynamic VL.

I mean that if I have X fields in Table A, and X VLs in Table B.

In Table B I use portal to Table A that shows Y field (Y<=x).

If I change the TYPE of the field displayed in the portal, then I want the VL also to change accordingly.

Am I making any sense ?

[-Queue-]

I'm not sure if a dynamic value list is really helpful in this situation. This is a case where repeating fields can help streamline the solution. See attached for changes. I've converted your five report fields and five results fields into two fields.

DynamicReport.zip

[Ugo DI LUCA]

Hmm...

Is it that if a value is selected, it can't be selected again for another column ?

[Ugo DI LUCA]

I need to know if it's the desire, having a hunch it has to do with this issue: http://www.filemaker.com/downloads/pdf/techbrief_fm7_foundations.pdf page 34 that gets almost incomprehensional when writing this:

[Ugo DI LUCA]

Hi again,

Actually, I went back to read this brief to check when this paragraph occured.

The page before is a graph illustration where you can see how the Teacher's data can't be displayed properly in the portal from AssignMents, just because of the not equal path, and why there's a Class2 and Teachers2 TOs.