Hi everybody,

I'd like to get your ideas in addition to mine for the following problem.

I have a TQM screen which displays certain fields in a grid. The cursor for the grid is created in the class code, then I'm running select to get the data, then append data to my cursor. So far, so good.

Now we want to display a different field depending on user's preference. E.g. currently I display Status field, but we may want to display Insurance Carrier for some users instead of Status. The select statement will have to change (field name and join condition).

I'm thinking how should I attack this problem.

Here are my ideas:
1) Add a new memo field to Profile table and put there
field_name|Join expression

2) Add a new field cExtra_Field to my cursor (assuming I always want to have character extra field - what if I want a field of different type?) and use this name in my select.

This would work, but there is one catch. This form calls another form, which may change information in my TQM form. Currently the changes are reflected using subject-observer mechanism from MereMortals framework. I'm not sure how to generalize this part.

Anyway, what do you think? How would you approach this problem?

Thanks for your ideas in advance.