View Single Post
Old October 30th, 2003, 11:42 AM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

If the only difference between the wto tables is the A andD fields, keep all of the info in one table. Your key will still be unique, because your A and D will make it unique. All you would have to do to get totals would be a big addition/substraction Sum(A)-Sum(B), and you would get the result. This may also simplify data entry.

I hope that makes sense.

Are there any other fields on each table that may be different from the other table? or contain different data?