Hi Jamie - welcome to FM and the community. I'm making a couple of assumptions here:
1. If your 'home screen' is based on a separate table (eg. menu) and if your dropdown is attached to a global field in the 'menu' table ...
Then you need a relationship between the 'menu' table occurrence and the 'business addresses' table occurrence - with the global field to the business name as the predicate in the relationship - see screenshot.
Which table is the home screen layout based on?
Which table is the business Address based on?
I assume you mean have a field, that's a drop down, tied to a value list of business addresses.
What you would want is a trigger, OnObjectModify, for one, that grabs the value and either goes to the related record, if the 2 layouts are related, or grabs the value and sets a variable, goes to the addresses layout, enter find mode, set the proper field to the variable, Perform Find
I believe you mean you have a drop down (no relationship required). IF it's a global field then it can work for any method, any user.
I would create a TRIGGER for the field.
Then when you change the value in the field by drop-down, the script is called.
something like this:
set variable ($myVar ; table::global_field) // store the value in the select drop-down
enter find mode
go to layout (.... wherever you need to find the record )
set field (table::searchfield ; $myVar ) // transfer the stored value to the field in find mode
sort (... if desired)
You can trap for nothing found or ...
You are searching for the value in the table/layout/report and then displaying.
does that help?