Hey there!
I have been building my Database for the last few months as part of my I.C.T Coursework, and have come to a standstill.
My Database is based on a "Film Rental Store" in which the employers will make sales e.t.c at a Film Store.
I had a ingenious (If I may say so
) idea, about be able to Search for Films in the shop, to allow customers to find a Film Specifically.
Now, I have done Part 1 in my idea. I am now successfully able to Search for a Film, through a query, which is placed upon a Form. Then the results are shown, and I have also added a Field to count the Number of Films found. The Query also allows me to Search for a few letters - For example (Search - Shr = Results are Shrek, Shrek 2 and Shrek 3).
Now here comes the standstill point. I have now decided, that I want to be able to search through a wider specification (Hereby the title - AdvancedFilm Search).
What my objective is, is to be able to search for a film, with the specifications being Movie Length, Movie Category, and possibly Actor/Actress).
I have got a Table Films, which contains the Film Name, Film Length, and some other Fields.
Another Table is Category, which is linked with the Films table.
So I finally come to the question (Thanks for reading this far
) - How do I search through a Category (Drop-down box), which then takes me to a movie length (i.e 0-120), and then the possibility of choosing an Actor/Actress, that starred in the Films that are left.
Sorry if I have not explained very clearly, and I will try and answer any questions to my best effort.
All thanks in advance.
- Jordan
I have been building my Database for the last few months as part of my I.C.T Coursework, and have come to a standstill.
My Database is based on a "Film Rental Store" in which the employers will make sales e.t.c at a Film Store.
I had a ingenious (If I may say so

Now, I have done Part 1 in my idea. I am now successfully able to Search for a Film, through a query, which is placed upon a Form. Then the results are shown, and I have also added a Field to count the Number of Films found. The Query also allows me to Search for a few letters - For example (Search - Shr = Results are Shrek, Shrek 2 and Shrek 3).
Now here comes the standstill point. I have now decided, that I want to be able to search through a wider specification (Hereby the title - AdvancedFilm Search).
What my objective is, is to be able to search for a film, with the specifications being Movie Length, Movie Category, and possibly Actor/Actress).
I have got a Table Films, which contains the Film Name, Film Length, and some other Fields.
Another Table is Category, which is linked with the Films table.
So I finally come to the question (Thanks for reading this far

Sorry if I have not explained very clearly, and I will try and answer any questions to my best effort.
All thanks in advance.
- Jordan
