Thank you for your reply. Your scenario is what I am used to
experiencing in the past. However, what is confusing me is this database
only has two tables. One named "Exhibitors" and another named "Cats &
Prods". The Exhibitors table seems to have the list of Category and
Product integrated into it and I cannot determine the source of the
relationship. It is not sensitive data so I can share the db with you to
help the explanation.
Tony
-----Original Message-----
From: Jeffry Houser [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 10, 2004 10:32 AM
To: CF-Community
Subject: Re: OT; Help; Pivot Tables
By pivot tables you mean intersection table that crosses Vendor to
product category?
You have three tables:
ProductCategory ( PKID, categoryname)
Vendor (PKID, VendorName)
ProductCategory_Vendor (VendorID, ProductCategoryID)
You can just run a query join to get the data you need, along these
lines:
select *
from vendor, ProductCategory_Vendor
where ProductCategory_Vendor.ProductCategoryID = #MyProductCategoryID#
and ProductCategory_Vendor.VendorID = vendor.PKID
I'm taking a lot of liberties on your problem here, so hopefully this
is
close.
At 02:04 PM 8/10/2004, you wrote:
>Subject: OT; Help; Pivot Tables
>From: "Tony Gruen" <[EMAIL PROTECTED]>
>Date: Tue, 10 Aug 2004 10:00:25 -0700
>Thread:
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadi
d=13714&forumid=5#124556
>
>Ok, CF Guys and Gals,
>I need a little help and I know we all work in some type of database to
>give our CF applications some power. So, here is my dilemma. I posted
to
>CF-Talk but I have not received one reply to my situation.
>
>I finally talked a small client into letting me update their website
>from HTML only to CF and get some portion of their database online. I
am
>having trouble figuring out how to get the Pivot tables in their MS
>Access DB into the SQL Server database I am using for the web for the
>category & product listing. I have little experience in Pivot Tables
and
>the data does not seem to be contained in any other location. It is
>vendor to product category and products data so it is standard info.
>There is no shopping cart, I just need to show what vendor offers what
>products in specified categories.
>
>I have been looking for info but short of going to buy an Access book
(I
>will at lunch today) it does not seem obvious on the surface. Maybe I
am
>brain dead after working all weekend or just stupidity. Please share
>your thoughts. I am in a vacuum here with no other resource for input.
>
>Tony
--
Jeffry Houser, Web Developer, Writer, Songwriter, Recording Engineer
<mailto:[EMAIL PROTECTED]>
--
AIM: Reboog711 | Phone: 1-203-379-0773
--
My Books: <http://www.instantcoldfusion.com>
Recording Music: <http://www.fcfstudios.com>
Original Energetic Acoustic Rock: <http://www.farcryfly.com>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
