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&threadid=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]
