Look up based on another field

[Guest]

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.

 

[George Walsh]

If the same fields of information exist regarding "branch 1" and "branch 2"
records which you presently maintain to two separate tables (except for the
designation of which Branch they belong to), perhaps all the data could be
held in one single table instead - with the addition of a "selector" field
that designates whether a record belongs to either "branch 1" or "branch
2".

Then you can use the selection input obtained from the user of your form to
set the filter on the form's recordsource so that the specific records it
feeds your form (i.e., from your table or a query based upon your table)
present only the desired "branch 1" or "branch 2" information for the form.

 

[George Walsh]

If the same fields of information exist regarding "branch 1" and "branch 2"
records which you presently maintain to two separate tables (except for the
designation of which Branch they belong to), perhaps all the data could be
held in one single table instead - with the addition of a "selector" field
that designates whether a record belongs to either "branch 1" or "branch
2".

Then you can use the selection input obtained from the user of your form to
set the filter on the form's recordsource so that the specific records it
feeds your form (i.e., from your table or a query based upon your table)
present only the desired "branch 1" or "branch 2" information for the form.