Well, it seems like you would only have 2 circumstances for each
store's
orders, right?
1) The person is ordering from the state where the store is located,
so they
get that store's specific rate.
2) The person is ordering from another state, so they would only pay
the
regular state rate.
Is that right?
If that's so, you could have one table with 51 records which would be
your
"Regular State Rate" table. Every time someone orders from a
different
state, you'd use the regular rate. Another table could have the
unique
rates for each store/state combination for when an in-state customer
is
ordering.
I'm not sure if that makes sense or not. It does in my head.
Scott
-------------------------------------------------
Scott Brady
http://www.scottbrady.net/
----- Original Message -----
From: "Jay Sudowski - Handy Networks LLC" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 9:45 PM
Subject: RE: Database Question??
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
