Why am I getting a "#Deleted" in every field for every record once I delete them from the Table? Is there any way to change this or do it better.
Scenario:
A user wants to back up his/her records in the database. He/she clicks on the button "View Full Table" to view the table, he/she highlights all the records and copies them to an excel document (or other media type), then deletes all the records in the table once he/she has backed them up.
The only problem is that if he/she had 100 records in the field, he/she now has 100 records full of "#Deleted" fields that they need to delete one by one (in form view) even though they do not display that way in the Table (since it is blank now)?
Anyone have an idea on how to fix, modify or make this a better way for them to back up their records?
Gord? (hehe)
Chance~
Scenario:
A user wants to back up his/her records in the database. He/she clicks on the button "View Full Table" to view the table, he/she highlights all the records and copies them to an excel document (or other media type), then deletes all the records in the table once he/she has backed them up.
The only problem is that if he/she had 100 records in the field, he/she now has 100 records full of "#Deleted" fields that they need to delete one by one (in form view) even though they do not display that way in the Table (since it is blank now)?
Anyone have an idea on how to fix, modify or make this a better way for them to back up their records?
Gord? (hehe)
Chance~