inputting data problem
In my relational database, I have a key field which is an ID number. It is formatted as a text, because the ID number can start with a letter. For some records, when I try to input data, I cannot update/add data to a certain field. For the most part, this seems to be the case when the ID number starts with a letter. I can update/add data in this same field for another patient as when I click on a field it allows for data entry (the cursor shows up and a yellow-orange box surrounds the field, indicating that the field can be modified). This yellowish box does not appear in the same field but for another record.