Hi there fellow programmers.
I am designing an inventory database (First for me).
What i need to do is track input and output and finally the staock in hand.
Now i have come up with multiple ways of doing this - (Designing the structure). The first being:
Just one table to hold both the input and output with one field to identify each from the other, since both the ins and outs have 80% the same fields. But then i would be wasting the 20%.
The Second way:
Have two separate tables and then join them using a Union and get all the required fields - all calculations are done on reports.
Can anyone please help me decide - or have an alternative solution.
Bert.
I am designing an inventory database (First for me).
What i need to do is track input and output and finally the staock in hand.
Now i have come up with multiple ways of doing this - (Designing the structure). The first being:
Just one table to hold both the input and output with one field to identify each from the other, since both the ins and outs have 80% the same fields. But then i would be wasting the 20%.
The Second way:
Have two separate tables and then join them using a Union and get all the required fields - all calculations are done on reports.
Can anyone please help me decide - or have an alternative solution.
Bert.