Creating a search field and button on a form to search and retrieve match from multiple tables?
I have various tables with phone circuits, and I need to create a form with a search feature if a circuit goes down or is impacted we can just type in the circuit id to see what locations are affected. The search needs to span multiple tables. Please help.