I'm trying to implement sales tax in our invoicing system and I was wondering if anyone has any comments or suggestions on how to do it.
We have a cities table that is used as a lookup for the client biliing address. It currently only has a field for CityName and a PK. I was thinking to add a state field and a SalesTax field and have the invoice determine the rate from there.
-or-
Should I have a SalesTaxArea table and link the cities to that.
-or-
Is there another better way to do it?
Any help would be appreciated. TIA
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!