Hi All,
I've created a new infomaker custom screen based on a new local table. I have one field which is defined as char(1) and is formatted as check box. When I load the form and update the check box with a tick, the database contains a 'Y' and the record will re-display correctly. However, I'm not able to uncheck the box. I can change the data in the other fields, but not the check box. If I re-set it back to 'N' in the database, it will display correctly as an empty box. I can then update it by checking the box again, but not uncheck it.
All the permissions appear correct in the local table. I've compared the properties of the infomaker field with others that are working and can't see the difference. Is there an 'Allow updates' field I'm missing somewhere? Or is there more to it than that.
I just know someone will have the answer.
Thanks
Debbie
Some things I'd double-check: does impusers have all of the required permissions re: the underlying table, i.e. update, delete and insert as well as select?
Also, in IM, all of my custom tab checkboxes have General -> Tag = 'N', Edit -> Data Value for On = Y, and Data Value for Off = N.
HTH,
Chris
Thanks for the reply Chris. I double checked and had all the table permissions set correctly and the General & Edit tabs already set as you suggest.
I think I've found another way of offering the same facility to the user which means I can delete the check box. Instead of a check box I'm giving them a date field which serves two purposes, if its populated it will, by default, mean a 'Y' and if its blank it will be equivalent to a 'N' plus they know when the record was created/updated.
Would still like to know what is wrong with my check box, but life is just too short!!
How frustrating. If I were you, I'd create a TASK support ticket re: this. The forums are nice, but your org is paying for Tessitura support, so you might as well use it!