[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity constraint violation: Primary key for row in table 'mi_def' is referenced by foreign key 'CFK2MI_DTL'
General SQL error.
in table mi_dtl.
First thing is not to be worried. This is normal behavior.
The reason you are getting this error is because micros keeps records of sales compared to menu items. So basically you cannot delete menu items which have been sold until those historical totals are purged.
See the Pos Configurator -> Reporting -> Historical Totals. This will show you how long each report hold data before they are purged.
If you don't want to use this menu item anymore you have a few options.
1) Reuse the menu item. Just rename it and edit all the options for a new item.
2) Clear all options including the name so its a blank menu item.
3) Renumber the menu item so that it remains in your system but is just out of the way. See the below pictures as an example. Most people don't have millions of menu items in their database so usually the 9000000 number range is blank.
When you double click on the number beside the menu item you can change the number. Change it to something in the 9000000 range or whatever you want and put it in that part of the list.