zeroaccess
Active member
- Local time
- Yesterday, 21:23
- Joined
- Jan 30, 2020
- Messages
- 671
I can't post this database at this time but I can provide a screen shot of the current situation. I'd like some input on this conundrum.
You have a parent main form and a child subform, each with its own table. The structure is inspections of products.
Samples of each product can not exceed a total lot size (number stored on main form in main table). Both samples and errors/defects are recorded on each line in the subform. That means with this structure, when inspecting products, there is a need to not duplicate your number of samples per product when recording many defects (otherwise you'd be saying you looked at 50+50 sprockets when there are only 50 total sprockets in the lot). You may find defects on multiple items. This is a hybrid approach that is built for speed and simplicity and the statistics work in the aggregate just fine.
But say you take issue with the zeros or say you wanted to make sure a user can never mess this up if they forgot their coffee one morning. I've worked out what should probably happen - that samples and errors be two separate tables, moving samples to another area on the form or a popup form. You would just enter them once. That eliminates the zeros and the need to manage that field for each item. The subform you see would then be only for errors/defects.
Is it worth it? Let me know your thoughts and suggestions.
You have a parent main form and a child subform, each with its own table. The structure is inspections of products.
Samples of each product can not exceed a total lot size (number stored on main form in main table). Both samples and errors/defects are recorded on each line in the subform. That means with this structure, when inspecting products, there is a need to not duplicate your number of samples per product when recording many defects (otherwise you'd be saying you looked at 50+50 sprockets when there are only 50 total sprockets in the lot). You may find defects on multiple items. This is a hybrid approach that is built for speed and simplicity and the statistics work in the aggregate just fine.
But say you take issue with the zeros or say you wanted to make sure a user can never mess this up if they forgot their coffee one morning. I've worked out what should probably happen - that samples and errors be two separate tables, moving samples to another area on the form or a popup form. You would just enter them once. That eliminates the zeros and the need to manage that field for each item. The subform you see would then be only for errors/defects.
Is it worth it? Let me know your thoughts and suggestions.
Last edited: