msmeth
10-14-2004, 10:49 AM
I'd like to know if I should have 2 tables for the following problem.
In my main table, a user inputs weights and the running net weight is calculated in the VB program. The user may enter and adjustment weight which will then be used to adjust the net weight. The adjustment weight is separate from the input weights...they can't change the input weights but can instead enter an adjustment to increase/decrease the net weight. Should these adjustment weights be kept in a separate table or just be another column in the main table? There will be few and definitely not all records in the main table with have an adjustment.
In my main table, a user inputs weights and the running net weight is calculated in the VB program. The user may enter and adjustment weight which will then be used to adjust the net weight. The adjustment weight is separate from the input weights...they can't change the input weights but can instead enter an adjustment to increase/decrease the net weight. Should these adjustment weights be kept in a separate table or just be another column in the main table? There will be few and definitely not all records in the main table with have an adjustment.