>>I have a need to access some tables using:
>>
>>USE (m.TableTo Use) IN 1
>>
>>I am trying refer to a field in the table this way:
>>
>>Variable = (m.TableToUse).fieldname
>>Variable = (m.TableToUse.fieldname)
>>
>>How is it done, please?
>
>
>First you should be using an alias, then a macro, execscript or STORE
>
>
>USE (m.TableTo Use) IN 1 ALIAS myTable
>STORE Evaluate("myTable.fieldName") TO Variable
>Sorry I didn't follow the whole thread, but why you have EVALUATE?
This is enough:
USE (m.TableTo Use) IN 1 ALIAS myTable
STORE myTable.fieldName TO Variable
Variable = myTable.fieldName
That is the whole point of the ALIAS, to name it :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
