Hi
The way to do this is to use the HidePrefix value in the load script, this will make sure that certain fields can be selected but will never show up on the current selections box.
In the load script, somewhere at the start, add the line:
SET HidePrefix='%';
Then, whenever you want a field to be selecteable, but not included in the current selections box, you need to alias it like this:
LOAD A, B, C AS %C FROM TableName;
So, field C can be selected, but will not appear in the selections box.
Note: the % symbol is what I use, but you can use anything you like in there.
Regards,
Nigel.
