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?

Reply via email to