Using dropdowns to drill down to a specific record to create a new list of selected addresses only.
I have three data resources, Streets, Addresses, and List.
The Streets resource contains only the street name (ex. Anystreet).
The Addresses resource contains 2 fields: full address (ex. 1234 Anystreet) and the order I want them to appear in the final List.
The first dropdown lists all the street names, I use the selected street in the second
dropdown to narrow the full addresses (ex. 1234 Anystreet, 1236 Anystreet, etc…). Then I select the full street that I want.
This works great but when I go to create a new record in a different data resource (List), I only save the full address and not the order key that is part of the full address resource.
I tried to set a page variable and use that when creating the record (object properties) with no luck.