As long as this is simply report values you can handle it this way
You can add some select fields and change these columnfields to calculation resulting in text
The calculation can be set to
Case [Colunm1Select = "Account" ; AccountField;
Column1Select = "Name"; Namefield;
Let me back up a little. I have a job table and an item table. There are many items per job.
The job table has these global fields - column1, column2, column3. Those fields also correspond to the column headings in the report. The user selects a value from a value list for each column.
The item table has these fields - field1, field2, field3 corresponding to the column fields in the job table.
The report has a header with the columns in it and the body has the field1 etc in it.
The user selects a value for each column from a value list.
When I used the CASE statement in the field definition for field1 etc. it worked fine -BUT- the values were inserted only if the item record itself was modified. I need those values to be inserted whenever the column1 etc are changed.
What I'm expecting to happen is the user selects the fields to be used for each column. FileMaker then creates a report with those fields. Your solution would work if the item fields were filled in whenever the job/column fields were changed.
What am I missing?
"Your solution would work if the item fields were filled in whenever the job/column fields were changed."
If your column header fields are global and you put the suggested case function as the definition of a calculated field. That's exactly what should happen. A change to the global field will automatically update the values seen in the corresponding calculation field. (You'll need one such calculation field for each column of your report.)
I made a dumb mistake in my definition of the column fields. Is partially working. I need to think about it overnight. <grin>.