Sorry if this is a basic question, but after reviewing many forum posts and videos, I cannot come up with a good answer. (I am using the 30-day evaluation so the Noob level is at max.)
I'm building a small proof of concept mobile application.
I have an Asset record that requires user-selection of an Asset Type from the CodeLookup table. These are tables in MS SQLServer.
The Asset Type column will require a lookup grid, list, Auto-suggest list or some other type of control for the user to see the Type Name rather than the numeric value from the CodeLookup Pkey.
The user will also need to be able to edit the Asset Type column.
CodeLookup
Pkey AutoIncrement
Id Varchar
Name Varchar
Asset
Id Varchar
Name Varchar
Type Integer
I am using the UX component with a List Control panel card and details panel card similar to the quick start mobile example.
I have experimented with the Grid Component and Auto-Suggest List controls but am having trouble displaying the Type Name and saving any new selection.
If I select a row from the list panel card, the details panel card displays the selected record?s data but the Type column displays the numeric value, not the Type Name. I assumed the mapping of Asset Type to CodeLookup Pkey would do this.
I can select a valid row from the Auto-Suggest List but when I save the record the Asset Type column is zero, not the CodeLookup Pkey I selected.
Any guidance or direction to an appropriate documentation topic would help a lot.
Thanks,
Nigel
I'm building a small proof of concept mobile application.
I have an Asset record that requires user-selection of an Asset Type from the CodeLookup table. These are tables in MS SQLServer.
The Asset Type column will require a lookup grid, list, Auto-suggest list or some other type of control for the user to see the Type Name rather than the numeric value from the CodeLookup Pkey.
The user will also need to be able to edit the Asset Type column.
CodeLookup
Pkey AutoIncrement
Id Varchar
Name Varchar
Asset
Id Varchar
Name Varchar
Type Integer
I am using the UX component with a List Control panel card and details panel card similar to the quick start mobile example.
I have experimented with the Grid Component and Auto-Suggest List controls but am having trouble displaying the Type Name and saving any new selection.
If I select a row from the list panel card, the details panel card displays the selected record?s data but the Type column displays the numeric value, not the Type Name. I assumed the mapping of Asset Type to CodeLookup Pkey would do this.
I can select a valid row from the Auto-Suggest List but when I save the record the Asset Type column is zero, not the CodeLookup Pkey I selected.
Any guidance or direction to an appropriate documentation topic would help a lot.
Thanks,
Nigel
Comment