Page 1 of 1

Pick List

Posted: Fri Apr 28, 2017 7:38 am
by HackinHoodLogicsTm
Hi NB Team.

Is there a way i can set a function when a selection is made in the Grid Table (PickList) from field properties

I have my table displayed in the grid this way

id | Hour | Time

Then in the Hour field i added a PickList (Day,Night,Other]

I want to set a function where and when if a user makes choice in Hour field
It could automatically update the Time Field

Please is this possible?

Thanks

Re: Pick List

Posted: Fri Apr 28, 2017 9:58 am
by Gaev
HackinHoodLogicsTm :

You can use the subroutine specified in dbpOpenTable ...

Code: Select all

dbpOpenTable "database id" "table" "subroutine"
When the user picks another value for Hour, this subroutine can check the new value ... and update the Time field accordingly.

Of course, this subroutine will be called for other field changes too ... but that should not adversely affect the value set in the Time field.

Re: Pick List

Posted: Fri Apr 28, 2017 12:41 pm
by HackinHoodLogicsTm
Thanks Gaev