Switchborad question

[matrix7410]

Hello,
I have a switchborad that lets you search Hollywood movies by Names,
by Directors, and by Year. But, I want to add Bollywood movies to
this database that will have the same search query; by name, by
directors and by year. So, I was thinking if I could add something
in the switchboard that will ask the user to slecte on of the
folliwng: Hollywood movies, or Bollywood movies. When user selects
Hollywood movies, than the swtichboard will open up with the query
that links to the Hollywood table, but if they select Bollywood, than
the same query will show up but linked to the Bollywood table. Can it
be done?

thanks!

 

[John Spencer]

Better would be to add one field to the movies table that will let you flag
the movie as Bollywood or Hollywood.

Then you can use the current switchboard.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County