Hi again,
I know how to do most of the following, but I want to ask how do the experts (you) handle this? I’ve run into headaches trying to back-out some of my newbie baby steps (fortunately I’m the user for now) and I’m trying to avoid this in the future.
When you are designing a form/subform (header/line item) with complicated validations that happen after the end of the last line item entry. Do you:
1) Enter items on the fly & back out the entries if they fail the validations. My intuition says no to this, but there may be good reasons I’m missing.
2) Place you header & line items into a buffer table & only move them over, en masse, to the real tables if all criteria are met. Maybe, seems straight forward to program but maybe there are good reasons to avoid this.
3) Use a system of memory buffers & then move header & line items, en masse, into tables if criteria are met. This seems to be the best but then again it may wind to be a real bear to program or am I over estimating the work involved in making this solution look like #2.
rafe
[sig][/sig]
I know how to do most of the following, but I want to ask how do the experts (you) handle this? I’ve run into headaches trying to back-out some of my newbie baby steps (fortunately I’m the user for now) and I’m trying to avoid this in the future.
When you are designing a form/subform (header/line item) with complicated validations that happen after the end of the last line item entry. Do you:
1) Enter items on the fly & back out the entries if they fail the validations. My intuition says no to this, but there may be good reasons I’m missing.
2) Place you header & line items into a buffer table & only move them over, en masse, to the real tables if all criteria are met. Maybe, seems straight forward to program but maybe there are good reasons to avoid this.
3) Use a system of memory buffers & then move header & line items, en masse, into tables if criteria are met. This seems to be the best but then again it may wind to be a real bear to program or am I over estimating the work involved in making this solution look like #2.
rafe
[sig][/sig]