The datacard doesn't have a value property...the control does. I listed that in the first post (it's set to unit table). The dropdown is populating correctly with all units...the issue is I can't pass the UnitID from the Employee table and select the correct Unit in the Unit dropdown.
It has to be something simple that I'm missing...this is basic functionality.
This sounds strange. My inclination is to use this syntax:
However, the formula that you wrote originally, and the formula beneath should equally work:
I suggest that you add a label to the same card and set the Text property to ThisItem.UnitID. When you do that, does the UnitID return the value that you expect for the record? To help diagnose this issue, I think it would be a good step to confirm that.
Thanks, everyone. As it turns out, the UnitID value was returning blank. After some troubleshooting, it was a weird error while converting from a SQL view to a table. Nevertheless, my original syntax worked once I actually got data from the source.
Sorry for the confusion.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200