I am creating a parts database and they are spread out in tables of which machine they belong to. I have created a search field for each individual machine to search for parts and I am wondering how I can search all of the tables at once. They have identical fields in each table. Thanks.