Linking multiple drop-down picklists to corresponding multiple data master fields
I have a data master comprised of geography attributes--theatre, region, country, state and so on. These are actually attributes of a flat address file.
I have dropdowns on the screen I want to be used as filters--ultimately for the data in a datasheet display. In other words, the user selects Country from the dropdown, and the datasheet refreshes with records pertaining only to that country, and so on.
I'm able to link single-column data masters to these drop downs, but I'm unable to choose a single field from a multi-field DM and link it. I've made my way to expression builder, and have done "on page load" SELECT->[data_master.attribute] and this seems to complete without error (many times), but nothing is ever displayed in the drop down.
Naturally, I'd really like the content of each dropdown to update and be restricted to values that correspond to one another--in other words, I'd like 5 separate drops downs that, together, reflect legitimate values of one row of the data master. But, I'd settle for completely uncoupled dropdowns that displayed anything at all from the multi-field data master I'm using.