Run time Error when running Z Report (-2147217900)(80040e14)

When I generate the report I get the initial filter screen, and when I click ok to view the report, I get the following error message:

"The report could not be loaded due to the following error: (-2147217900) Cannot truncate table 'Cashier' because it is being refrenced by a FOREIGN KEY constraint.

Reply to
Daniel
Loading thread data ...

The table keys only seem to reference themselves, so check your table for integrity. If you don't know how to do that, try deleting the cashiers and reentering them.

-Jerry

Reply to
JerryData

hi..... Thank you for help for me...

Actually, We have 2 cashier(Admin, me) and We delete cashier 'me', but following Error MSG again

Run-time Error '-2147217873(80040ef) Delete statement conflicted with COLUMN REFERENCE constraint 'FK_NWT_Mobile_cash_392E6792' The conflict occurred in database 'bsw_vic1' table 'NWT_Mobile cashier',column 'cashierID'.

How to do.......Please..

"JerryData" wrote:

Reply to
Daniel

Hi. You most likely have a bad table entry field (it happens). The only thing I can think of doing for this is to go into the database to see the table. You most likely need to correct the table entry... One way to do this is to go to the RMS Administrator and you can do a query to see what's in there. type: (first part you can cut & paste the hit the green arrow:) SELECT * FROM Cashier (then click the green arrow) This will show you the table entries. Note the ID # of the bad entry and the bad field. Look closely! Then type an UPDATE statement that makes the correction. Example: UPDATE Cashier SET [Name]='me' WHERE [ID]=7; Then hit the green button.

If this doesn't work, go to the sql2005 Express manager (download it from Microsoft if you don't have it). Once you attach the database you can go right to the table and correct it. If you still can't get it, I'd be happy to look at it via remote. (I doubt I would charge you for this, it is probably a 2 second thing)

Reply to
JerryData

hi..... Thank you for help for me...

Actually, We have 2 cashier(Admin, me) and We delete cashier 'me', but following Error MSG again

Run-time Error '-2147217873(80040ef) Delete statement conflicted with COLUMN REFERENCE constraint 'FK_NWT_Mobile_cash_392E6792' The conflict occurred in database 'bsw_vic1' table 'NWT_Mobile cashier',column 'cashierID'.

How to do.......Please..

"JerryData" wrote:

Reply to
cptsoft

hi.... Thank you for help me........ Then We still problem.... so, Could you look via Remote... I leave phone number......416-508-1355 (Daniel) Or leave your Phone number.....Plz

"JerryData" wrote:

Reply to
daniel

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.