>>Right, I had to de-normalize half of tables :) in an app I wrote a couple of years ago because of that invoices history problem...
>>
>
>Nick,
>
>You're mistaken, what you really had to do was normalize them. John's example, if the rate was not in both tables then it would not be normalized because there would be an attribute missing for the Calls table.
Probably not, because I did exactly what Erik said, Well if this is what is called
normalization... :)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison