S
Sandra
I have a database for ticket sales. I have a main form
which allows the user to select a patron from a list.
Within this form I have a continuous subform where the
user can select tickets to be sold to the patron from a
table which lists 1700+ seats (tickets) in the
auditorium. All this is linked and works as expected.
However, I have found that scrolling down thru 1700+
tickets to select the right one is tedious, so I have
created a parameter query where the user can enter the
Row and Seat# and the query will include all the
information about the ticket i.e. TID (ticket ID PK),
then Row, Seat, Class, and Price.
So now I need help to put this all together!
What is the best way to access the parameter query and
how do I pass the information from the query to the
fields in the ticket sales table for each ticket sold to
the patron (one patron may purchase several tickets so I
need to do the parameter query for each ticket sold?).
TIA,
Sandra
which allows the user to select a patron from a list.
Within this form I have a continuous subform where the
user can select tickets to be sold to the patron from a
table which lists 1700+ seats (tickets) in the
auditorium. All this is linked and works as expected.
However, I have found that scrolling down thru 1700+
tickets to select the right one is tedious, so I have
created a parameter query where the user can enter the
Row and Seat# and the query will include all the
information about the ticket i.e. TID (ticket ID PK),
then Row, Seat, Class, and Price.
So now I need help to put this all together!
What is the best way to access the parameter query and
how do I pass the information from the query to the
fields in the ticket sales table for each ticket sold to
the patron (one patron may purchase several tickets so I
need to do the parameter query for each ticket sold?).
TIA,
Sandra