Invalid (blank) occupation in list?

[clinicoffice_userParticipant]

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.

[Mat Larkin]

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.

[Author]

Posts