I have a parent gallery "Affiliate" which when an item is selected, filters a child gallery "Salesperson" based on the lookup column within it: "Affiliates."
The selected item within the "Salesperson" gallery also displays in a form and all seems to function well.
I would like however, when an item is already selected in the parent gallery "Affiliates," for a new "Salesperson" form to pre-populate the affiliate combobox with this selected Affiliate.
To do this, I have tried entering
gal_Affiliates.Selected.Autonumber
in the Default property of the combobox.
It complains however that the value is "text."
What would be the right kind of formula to pre-populate the combobox?