On 25/02/2008, Richard S. Russell <[EMAIL PROTECTED]> wrote: > On 2008 Feb 25, at 12:31, Loretta James wrote: > > > I think I don't fully understand how this works. I want to show only > > particular types of ticket types coming from the pricing table as I > > create records in 'what events are in what series sold" table ... a > > multi to multi join table. > > > Let me see if I can gin up an example to make sure I understand what > you're getting at. > > Let's say you've got a "Prices" table with the fields "Series", > "Event", "Price", and these are some sample entries: > > Concert • Jazz Pres Band • $55 > Concert • Moscow Philharmonic • $100 > Concert • City Symphony • $75 > Concert • Youth Symphony • $45 > Chamber • Haydn String Quartet • $40 > Chamber • Brass Choir • $30 > Chamber • Rach On • $30 > Chamber • Overtures for Piano • $35 > > Then you've got a "Reservations" table in which you've got a field > called "Series", into which you'd like to enter: > (a) "Concert" and get a drop-down list with the options Jazz, Moscow, > City, and Youth OR > (b) "Chamber" and get a drop-down list with the options Haydn, Brass, > Rach, Overtures > > Is this a general idea of what you're trying to achieve? > Thank you Richard!
Close ... this is how they 'sell' .. by concert OR series. Concert - Emmanuelle Ax Concert - YoYo Ma Series - Super Classic Series - Classic Afternoons Super Classic series has all the concerts for the season. Classic Afternoons is a particular venue on Sunday afternoons. Each year the series have different concerts .. obviously. They have 5 series ... hence the many to many. L J
