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?