>No the tax code is only in the taxcode table. Points to the customer (has a tax code key) points to a tax rate (ergo reads) in the tax table. Some rates, like late penalties, or price breaks would be in the customer table since they may be customer specific. List link as much as possible.
Terry,
So how does the customer table "point" to the tax code table? Probably using the TaxCode Attribute Right? And the Invoice table also uses the TaxCode Attribute to "point to" the tax code table. Are these two TaxCode attribute (the one in the customer and invoice tables) redundant? Example;
TaxCode Table
Fields
TaxCode PK
Tax Rate
Effectivedate
Customer Table
CustID PK
...
TaxCode FK to Taxcode (A)
Invoice Table
InvNo PK
TaxCode FK to Taxcode Table (B)
Now are the two fields marked A and B redundant?