Share
Report
183Hi All,
Not sure where to start with this one. I have created a dialog box on my browse screen. When the user selects the "OK" button it needs to update a field named "treatEnd_dt" in table named "tbl_treats" where the field named "treat_id" = the variable named "varTreat".
The browseGallery is set to filter records based on the variable "varTreat" so it only shows records for that specific treatment selected in the previous screen. When the treatment is completed the user can select the completed icon at the top of the screen which opens the dialog box and asks them if they are sure they want to complete the treatment. If cancel is selected then nothing happens and the dialog closes, but I am stuck on the "ok" button mentioned above.
browseGallery items set to:
SortByColumns(Filter(tbl_treatLog, treat_id = varTreat),"treatLog_dt", Descending)
I hope that I have explained correctly, please let me know if you need further info. Thanks in advance for your help.
All responses (
Answers (
