I have various applications that use group by in popup menus to present a distinct list of values. I have a new application where I cannot get it to work (where clause below).
WHERE MFGCODE =.vMFGCODE group by MFG_STYLE (The table name is UPC_MASTER) When I select the popup I get the following error message: "Illegal column specification (2512)" MFG_STYLE is a valid column name in the table being accessed by the popup. It is also the value being returned. This command works fine: sel mfg_style from upc_master whe mfgcode = .vMFGCODE group by mfg_style Any idea as to why it does not work? John
