Does anyone know what tables the Merchandise table links to?

I'm not exactly sure what you are looking for? Parameters is what merch is under. RPM

This is a database query question. In Microsoft SQL Server, I can find the Merchandise table, but I don't know what table tracks the Merchandise sales. The ReportStatic table tracks event ticket sales and SubReportStatic table tracks subscriptions, but I just need merchandise sales. The Merchandise table doesn't track what has actually been sold, it just tracks what merchandise is for sale and what the current inventory is. I'm looking for the equivalent of the ReportStatic table for merchandise but there are so many tables to search through. This table isn't documented in the Crystal Reports Runtime viewer documentation. [i]--- Edited at 4/10/2007 9:51:36 AM by Derrick Brown[/i]

The MerchandiseItems table is the onethat contains the items you're selling. The Merchandise table contains the actual sales you make. Paul Bair Lincoln Center for the Performing Arts Box Office System Administrator 212-875-5304 [Email Removed]

Thanks! That's what I needed to know.