I’ve created a Form for data entry. In a Grid Control I can enter in the values (Skill and Level), it confirms whether the Skill item is in a reference table, and it will add the values to the current record.
When I change the entry method in that grid to a dropdown list, It shows the proper list of items, but throws an error when I move to the next entry. I can’t figure out why.
Here are screenshots of both setups, and the configuration of the field.
Listbox will show value “Athletics” and should also save “Athletics”? Then in Data properties the “Bound Field” should be ‘0’. Don’t know the fields of table “SKILLS”, but when I see the second screenshot it seems the first field is “Skill” there.
I changed the Bound field to 0, but field just gets deleted. Is that expected behavior? Either way, it seems to do the trick. Now I need to figure out how to delete entries within that control, so I don’t have to go to the table to fix my mistakes.
Thankyou.
Oh, what exactly does that bound value refer to? I though it was the target column, but the data is recorded into column 3 (or would that be two?)
Bound field ‘0’: The first field of the table, which is datasource for the listbox, will be saved in the row of your form.
The “normal” SQL for a listbox is:
SELECT "Name", "ID" FROM "Table"
“Name” is field ‘0’ or Bound Filed ‘0’
“ID” is field ‘1’ or Bound Field ‘1’
Listbox is often set to Bound Filed ‘1’, because the “Name” will be shown in the box and “ID” will be saved in the row of the form.