/ english descriptions for underlying codes. I currently have to open an
/ extra 35 files(lookup tabes) just to display the english. Their must be
If a function call can be used as an ControlSource for a grid element,
that's it. Anyway, I feel Fox (well, MS) must have made grids fully
functional in order to create a browse-killer. If it was possible to put
browse field xx=fn()
then I suppose there must be a possibility to do the same in a grid.
/ What I have is a Parent table named "client". One of the fields in
/ client is status. The status field contains a code.
I use a function like this for retrieving the array element from the
element number and array name:
Function Statc
Lpara what, arr, column
if para()=2
column=1
endif
external array arr
if alen(arr,1)=alen(arr)
retu iif(betw(what,1,alen(arr)), arr[what], " ??")
else
retu iif(betw(what,1,alen(arr,1)), arr[what,column], " ??")
endif
I suppose you could leave the column source property blank, and from
some other event fill the column value with like this
{column_reference}.value=statc(status, @array_name)
if it proves to be impossible to set source to a function call; if it's
possible, simply
.controlSource=statc(status, @array_name)
Passing array by ref is essential; passing by value passes only the
first element.