@Anonymous
Yes, so you're going to be relegated to doing this manually as there is no way to get the column names in a list, nor to determine the corresponding record to write. This again is another major reason to consider a master/child related table for your bins. Those you would very easily be able to do in the app.
Otherwise, your Items property of the Bin dropdown is going to have to be a hand-written list of column names, but that by itself will not give you what you want because you're then expecting to lookup the corresponding value for that column to display in the amount entry...and then needing to figure out how to put that back into a usable record for the update.
This can be done with a lot of Switch and If statements, but there is another slightly simpler way to go about it.
Since your Form will default to having all of the bin names, you can utilize the Visible property of the DataCard for each bin datacard.
So first, you would need to manually add all the bin/column names to the dropdown. So the Items property would be: ["a01b", "a02a", "a02b", ...etc...]
Then, the Visible property of your Datacards for those bins would be: yourDropdown.Selected.Value = Self.DataField
This would make any datacard corresponding to that dropdown selection visible.
Your form would function normally at that point with a normal SubmitForm. There should really be no other changes to anything in the datacards for the bins.
