Why do you say it needs a purchase table ... there is the tickets, the pricing for the tickets and then the ticket sales ... which is the one I'm working .. .. ticketsales to people
On 14/02/2008, Jason L DeLooze <[EMAIL PROTECTED]> wrote: > Yes, it will work. People purchasing Tickets (a many-to-many relationship) > should have a join table (Purchases?) between them - unless you are using a > multi-key link to eliminate the join table. Either way, a GTRR[ Found Set ] > from Tickets to People will grab all People who purchased a Ticket in the > Tickets Found Set. Just make sure you are using the People table occurrence > and the Tickets table occurrence which are properly joined by a relationship > (or joined by the Purchase join table). > > Best wishes, > Jason L. DeLooze > Annapolis, MD USA > > > On 2/14/08 at 6:37 AM -0800, Loretta James wrote: > >Thank you Gentlemen, > > > >It is a new world indeed! I'm actually going from child to parent ... > >so there are many records with the multiple same ID and I want only > >the people that bought them. So from these purchased concerts give me > >names of the people that ought, so from ticket sales back to contacts > >... still gonna work?? > > > >Loretta >
