open database (home()+'\samples\tastrade\data\tastrade') shared use (home()+'\samples\tastrade\data\tastrade.dbc') again alias dbc_tastrade shared select objectname from dbc_tastrade where parentid in ; (select objectid from dbc_tastrade where upper(objectname) = 'CUSTOMER' ; and upper(objecttype) = 'TABLE') ; and upper(objecttype) = 'FIELD' use in dbc_tastradeThe above query circumvents having to open the customer table and issuing an AFIELDS() on it simply to get a list of fields.