I've gone ahead and rewritten all my search routines to add a request for the current show. I've had to make things a bit more restrictive, which in the long run is probably better. Everything seems to be working alright except for one thing that I can not seem to get past...
Value Lists.
I...
Thanks again JeanW :-)
My only concern with keeping everything in 1 file is having to make sure that the user is only seeing the Scenes, Characters, Costumes, etc. that pertain to the current show. I can imagine the user performing a find, and getting Scenes from several different shows unless...
Thanks for the response JeanW.
The main table in my solution is Shows. Shows are made up of Characters (of which there are many per Show), Scenes (of which there are also many per show), and Costumes (of which there are many per Character). If each one of these elements is a table in my...
I developed a database for my costume designer girlfriend to use when she breaks down scripts. It worked beautifully for the last show she did, but its time for her to start breaking down another script, and currently the database doesn't handle multiple shows.
What I've had to resort to is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.