Trying to make a seat ticket reservation something.

I have from the main page, seats(images with script) that I click and and with some scriptstep I reserve in another table inside a field for reservation (just picked a value: 0) and I can reserve more than one at the time.

Ready for printing, a scriptstep send them to the printer and now I should clean the reserve fields, flag it as sold in this record and the other records in the foundset, and flag the seatfields in the main page that is corresponding to the seats actually ordered. There I have a textfield that should fill the seat reference from the sold/printed ticket and a container(to fill with color flagged as sold).

In the next step I'm stuck. I don't know how to connect to the right fields to fill (the seat ref and container) in the main page.

What is your relational setup?

I am thinking that you should have at least the following:

Event

Seating (Seating Chart)

Booking

When a seat is booked for an event, a related record should be created in Booking. You can then use a calc or a relationship to display the container image for not available.

Yeah, I could do that. I just thought about an extra step for reserved, and after the printout, it should be booked.

The reserved step I'm thinking of, is if it should be more clients on the DB doing the same thing.