I have a custom form in my app (a table in my database) where I can enter tastings for a beer in my database of beers. The user first selects a brewery, which then filters to the available beers in the database, and then the user selects a beer. The filter uses this Valid If function:
ORDERBY(SELECT(Beers[BeerID],[BreweryID] = [_THISROW].[BreweryID]), [Name])
This works great. The only annoyance is, if the beer doesn’t exist in the drop down and you want to add a new one, you click New at the top of the Beers drop down and it brings you to a New Beer page, which forces you to select the brewery again since the new page doesn’t have any knowledge of the old page.
Is there a way to fix this? I’d like it to pre-populate the Brewery name with the one that has already been selected.
Thanks!