Hi Mark,
Thanks for help. One question, is the tax area assigned to the customer automatically? Do you do that by matching the customer city against the TaxArea city?
>I use a sales tax table. My customer table has a FK field with the TaxArea [PK] value from my TaxArea table. In my TaxArea table I have the following fields:
>
>TaxArea I
>City C(40)
>TaxRate N(9,6)
>ExemptRate N(9,6)
>StateRate N(9,6)
>
>The Exempt Rate field seems superfluous because in all cases [except 1] I have encountered that rate is 0%. In Louisiana all tax exempt sales are still taxed at 4%. If you need more breakdown, you could include a CityRate, MetroRate, CountyRate, etc. All depends on your level of detail needs.
>
>In my Invoices table I do have to duplicate these rates for all invoices in case the current TaxRates change [and they always do]. That way I always have a history with the invoice of what the sales tax rate was at the time of the old invoices.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!