Advanced Film Search

Jk45

Registered User.
Local time
Today, 20:32
Joined
Oct 22, 2007
Messages
12
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 :rolleyes:) 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 :)
 
so you want to filter your results based on what the user picks in the dropdowns?
 
I think that would be the best option.

I would prefer to be able to choose the category, then length, then possibly actor/actress, using filters.
It would also help, if you didn't have to choose a Movie Length for example.

If you know any solutions, I will be very thankful.

- Jordan
 
well you have some options here
i think your best option would be a subform that is filtered based on what is selected in the combo boxes. the combo boxes themselves will need to be "cascading" which means they are dependent on each other.

take alook around for cascading combo boxes and see if thats something you want to add to your project
 

Users who are viewing this thread

Back
Top Bottom