i'm using flamerobin [generators and triggers for autoincrement] for making database and delpihi for interface.
movie_price_group is for 'premiere'=1, 'old'=0,8, price_group is for 'mon-thu'=5$, 'weekends'=8$ i thought it could be usefull for calculating prices of tickets -> movie_price_group * price_group ...
In form1 i will make a view from tabels seance+movie+movie_kind+movie_age_restriction
i'd like to show
MOVIE title, time, SEANCE start,MOVIE_KIND name(ex. horror), MOVIE_AGE_RESTRICTION name(ex. 18)
i will make search engine by movie title. when i choose movie i'll go to form 2
with ideseance, idmovie and idroom (SEANCE) i'd like to paint all free [which are not in table TICKET] seats from room_has_seat
then form3 with info seat_no, row_no, date, start(seance start), title, cost