Hello!
I need some serious help with my database, I am struggling badly with my database in doing my validation, error messages and queries.
What I need help with is this,
• Set up a form to allow the input and display of details of a Show. For example the user should not have to remember the valid types of show (comedy, musical etc). For the validation, rehearsals can’t end before they have started, the run of the show can’t start before the rehearsals end, and it doesn’t make sense to have a show without a title. Make any error messages displayed to the user as informative as possible. This is one of the big problems I have.
• It should also be possible to enter the Roles needed for each Show. I would of liked to create this as a subform of the Show form described above. I find this very hard to do.
I also want to learn how to do queries as AGAIN I am not that good. Here are the queries I would like help with.
• A list of the details of all performers, ordered by age.
• A list of the details of all performers with ages between a specified minimum and maximum age, ordered by age.
• A list of shows that will be running on a specified date. Note that there could be more than one show as one show could be on in the theatre in Greenwich and others could be on tour. The details to be displayed are the title, type and start and end date of the run.
• A list of roles that have not yet been filled that are suitable for a specified actor according to age and gender. The details to be shown are the role name, the minimum and maximum ages and the gender.
I have attached my database so that you can help me along the way. I really would like some help with this so one day I can help others
Thanks
I need some serious help with my database, I am struggling badly with my database in doing my validation, error messages and queries.
What I need help with is this,
• Set up a form to allow the input and display of details of a Show. For example the user should not have to remember the valid types of show (comedy, musical etc). For the validation, rehearsals can’t end before they have started, the run of the show can’t start before the rehearsals end, and it doesn’t make sense to have a show without a title. Make any error messages displayed to the user as informative as possible. This is one of the big problems I have.
• It should also be possible to enter the Roles needed for each Show. I would of liked to create this as a subform of the Show form described above. I find this very hard to do.
I also want to learn how to do queries as AGAIN I am not that good. Here are the queries I would like help with.
• A list of the details of all performers, ordered by age.
• A list of the details of all performers with ages between a specified minimum and maximum age, ordered by age.
• A list of shows that will be running on a specified date. Note that there could be more than one show as one show could be on in the theatre in Greenwich and others could be on tour. The details to be displayed are the title, type and start and end date of the run.
• A list of roles that have not yet been filled that are suitable for a specified actor according to age and gender. The details to be shown are the role name, the minimum and maximum ages and the gender.
I have attached my database so that you can help me along the way. I really would like some help with this so one day I can help others
Thanks
