I thought I was being clever and created a seemless-looking form where data is being entered into multiple tables by placing subforms on the main form. Now I'm running into the issue where the "cancel" button doesn't work once focus enters a subform because the record has been saved.
I guess my question is whether or not this is a frustrating limitation for most people. If it's not, it must be my design that is flawed. I don't see any functional reason why I couldn't put more of my data into one table since it would always be 1-to-1 anyway, that would solve it. Or I could try to work on some kind of temporary table solution.
If a user creating a record is always going to fill in details that go into multiple tables in a 1-to-1 relationship, how do you handle it?