At 05:32 PM 04-11-02 -0500, you wrote:

>Select mc.MenuCategoryID, mi.MenuItemID, mc.CategoryName, mi.ItemCode,
> mi.ItemName, mi.Price, mi.Sales
> >From xMenuCategory mc JOIN xMenuItem mi
>ON mc.MenuCategoryID = mi.MenuCategoryID
>Order by mc.CategoryName, mi.ItemCode
>
>The error is:
>****************************************************************************
>**
>Project xxxxx.exe raised exception class EIBO_ISCError with message 'ISC
>ERROR CODE:335544569
>
>ISC ERROR MESSAGE:
>Dynamic SQL Error
>SQL error code = -204
>Ambiguous field name between table XMENUCATEGORY and table XMENUITEM
>LOCATIONID
>
>STATEMENT:
>TIBOInternalDataset:"<TApplicatoin>.DM.qryManSales.IBOqrqryManSales.'.
>****************************************************************************
>**

Where does the field LOCATIONID come from? Is it part of your KeyLinks?

Could you post the actual SQL statement as seen in the monitor?

regards,
Helen