How would you handle this?
I have a database table for sales tax that has the following fields:
State, TaxRate
I was using individual tax tables for each store so each table would have 51
records (includes the 50 states + Washington D.C.).
I would like to run multiple stores through the same database. This is why
I added the a storeid field making the fields State, TaxRate, StoreID. The
only problem is that I would need to add 51 records for each store I add.
Does anyone have a better idea on how I could setup this table?
Thanks,
Rich
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
