Topic: Delete on cancel to avoid blank record
I have mentioned something similar before but couldn't find any solution.
There is an issue with MVD when two stages of adding a new record used. I can understand that in order to save second level it needs to save first level after initiating second level add new records as a blank or incomplete record. It's all fine up to here. However, when I click on cancel button on level 1 form, I'd like blank or incomplete record to be deleted rather than deleting them manually on main form tGrid.
Please see attached MVD sample project student performance db.
1. On main form click on add student button
2. On student form I made last name field required to avoid saving totally blank record. Then click on add button to add a test after putting some value in last name field.
3. On test window I add some details or cancel without adding any details.
4. Back to student form, I decided not to save the record by clicking on CANCEL button but MVD saves the record. What I'm looking for on click of cancel button, record is deleted and now shown on main form tGrid.
Cancel delete applies when adding new record not when editing existing record.
------------
God... please help me become the person my dog thinks I am.