I have a database that tracks information from two unique branches. I have a look up in a form that prompts "Branch 1" "Branch 2". I also have two independent fields linked to two tables that are dependent on the input from "Branch". How can I make the independent fields look up from the correct table based on the selection in "Branch"? Any help would be great.