Share
Report
433I have a list of master records, that I load On Start. Those records have a key field, plus a formatted display field based on that key field, added as a column in the ClearCollect statement. That statement is working correctly. The app uses a combo box to select one record. Then it looks up the selected master record and uses it for selection of the child records to be displayed.
If I display the key field in the combo box, the app works. If I display the display field, I need a way to access the corresponding key field value. Other than reverse-formatting the display field back to the format of the key field, I am not finding a way to reference the corresponding key field. Only the displayed value from the combo box is available with Selected.
Ideally I would have records with the key and the display fields for each master record. When the user selects one of the display values, I would use the corresponding key field to look up the master record, which I would then use to retrieve the related child records.
Any suggestions? I haven't listed my code here in detail, hoping that I have described the essential parts sufficiently.
All responses (
Answers (
