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

    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.


    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.