I am starting a data base from scrach for a library of video tapes. The way my company wants them set up is in categories. I have created tables for each of the differnt categories and assigned fields (which are all more less the same for all the tables). What I want to acheve frome this is a way to search for example a speekers name and get a list of all the videos that person sopke in by combining all the differnt tables. What is the best way to do this?