SQL Field greys out after it is initially populated with data
Posted on 2013-11-06
I am doing some development with the NCR counterpoint POS system. I have the SA password and have access to the SQL database and tables.
My question is: on the main form, a cost field initially allows for null values. So, there can be no data entered in the field, and the record can be saved. However, after this field becomes populated and the record is saved , the field greys out, and becomes uneditable on that form. If a user makes a mistake and wants to correct it, or if the user wants to update the field he/she has to go thru a cumbersome process into the "purchasing" portion of the program, create a false PO, and also "receive" the item in the system to update the cost.
I realize this is the way the software is designed to work, however, I am currently in the setup process of this system, so I was wondering if I could make that field not grey out after it has initially been populated with data. After the data is populated, I will switch back the field before the system goes live. This would be extremely helpfull with the setup process.