Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #31071

    clinicoffice_user
    Participant

    one of the girls has managed to create a blank entry for the occupation field in the patient record, leaving this blank entry means we can no longer edit the occupation list. I would be grateful if you would let me know how to remove said blank entry to enable us to enter new occupations.

    #32407

    Thanks for your post. To fix this, please do the following:-

    [1] Click the Tools tab
    [2] Click Advanced DB Operations
    [3] In the text box copy & paste in the following code :-

    delete from occupation where name='' or name is null

    [4] Click the Execute button.

    I hope this helps.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.