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

Reply via email to