Ok, so here is the issue. My database builds tables based on the unit the person belongs to, then whoever is inputting data can change whatever data they need to for a person by scrolling through AFTER they pick the unit. The problem is, I have been asked for someone to search ALL the tables (no relationship between any table) for ANY criteria (I plan on using a form to request what the user wants to sort by). The problem is, I don't know how to call all of the tables together for one block of records matching the criteria. I am stumped for an idea! I have no code already written for this portion of the program. Any help will be appreciated as soon as possible.