This may be a simple (or even dumb) question:
I have a multi-table database that tracks event tickets. When I place an order for say, 8 tickets. I use a forum to add the order and tickets to their respective tables.
Within each order, the values for each ticket field are the same (section, row, price) EXCEPT for seat number. Rather than enter 8 records, I'd like to just be able to input the first and last seat number (1 and 8 for 1-8), and have Access create 8 records in the ticket table (seats 1, 2, 3, 4, etc.)
What is the easiest way to do this? I don't mind programming some VB if I have to, but if there's an easier way, I'm open to that as well.
Thanks,
Mike