Two questions, probably dumb but I am still new to CASPIO
I am using List String and List Number data types in tables and populating the options from the contents of other tables. This works nicely.
What I would like to do is the following with an example.
The Employee table field DeptCode is a ListNumber sourced from table Dept. The dropdown on the Employee Creation form shows the list of possible departments which is great, but I would like the dropdown to show the department number (as it does) but also show the department name value for that record in the Dept