Hi Scott -
I think it could vary from store to store - because in some states the
sales tax varies from county to county. I know in CA the rate varies
depending on where the business is located. (Or, at least, I think it
works like this. I could be mistaken).
Jay
-----Original Message-----
From: Scott Brady [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 11:34 PM
To: CF-Talk
Subject: Re: Database Question??
Umm . . . why does each store need its own sales tax rate for each
state? Does the sales tax vary from store to store?
Scott
-------------------------------------------------
Scott Brady
http://www.scottbrady.net/
----- Original Message -----
From: "Rich Tretola" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 9:33 PM
Subject: Database Question??
> 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?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
