So you have this relationship:
People::People_keyID = Addresses::People_keyID
Addresses appear in a Tab window, I can currently display all addresses in multiple rows, but that's not the goal.
What do you mean by a "tab window"?
If you put a portal to Addresses on your People layout, you'll see all address records for that People record.
You could set up a filtered portal where a filter expression uses the contents of your drop down to filter your portal down to just one selected record, but given the extra steps needed to handle screen refresh issues, let's handle the issue at the relationship level.
In Manage | Database | relationships, make a new table occurrence of Addresses by clicking it and then clicking the duplicate button (2 green plus signs). You can double click the new occurrence box to get a dialog to appear where you can rename the new occurrence box as SelectedAddress.
We have not duplicated a table. Instead, this is a new reference to the same table already present in your database.
Add it to your relationships like this:
People::People_keyID = SelectedAddress::People_keyID AND
People::AddressType = SelectedAddress::AddressType
People::AddressType would be the field you format with your drop down list.
With this relationship, you can add fields from SelectedAddress to your layout to show the address selected from your drop down.
Some glitch with my browse submitted my post before I finished typing it. I've edited the post to complete it, but this won't fix any notification appearing in your email.
Thanks for the quick response. It worked great!! I never would have thought of a second "view" of the same table with a second relationship that showed only selected items. My background would have been to write reams of code... I think I like FMP. BTW, the "tab window" is just a tab control so I can do other stuff in the same space besides just show addresses.
We call those "views" table occurrences. They're a key tool to use in many different aspects of FileMaker data modeling. See this thread if you'd like to learn more: Tutorial: What are Table Occurrences?