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]

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

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 ?

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

Hmm...

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

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:

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.