I have a slight problem.
A record appears to have been deleted by a User in error from a stock table.
I tried to modify the record in the table but the error "record is deleted" will not allow me to edit it.
So i created a new record to ensure we had stock integrity.
Now i want to remove the old "deleted" record from the table.
This is proving most difficult to achieve.
I can delete any other entry from the table, including the deleted one, however as soon as i open the table again the deleted record reappears.
I have removed all of the relationships so that the table is stand alone but still the same thing occurs.
ANYONE ANY IDEAS WHY??? & HOW I CAN RESOLVE THIS
A record appears to have been deleted by a User in error from a stock table.
I tried to modify the record in the table but the error "record is deleted" will not allow me to edit it.
So i created a new record to ensure we had stock integrity.
Now i want to remove the old "deleted" record from the table.
This is proving most difficult to achieve.
I can delete any other entry from the table, including the deleted one, however as soon as i open the table again the deleted record reappears.
I have removed all of the relationships so that the table is stand alone but still the same thing occurs.
ANYONE ANY IDEAS WHY??? & HOW I CAN RESOLVE THIS