Multiple similar Tables in you database, is it possible to run queries etc by pre selecting.....

Hi, I have a number of similar linked sharepoint lists in a database, specific to different job sites, is it possible to run queries and forms on a particular job only, by selecting the job I want to...