Hello all
Thanks for any help. See attached file.
First I know it's a crap database structure and I am endeavouring to change this. I am not a professional, just trying to set up a small database to help me look after patients.
On the "Select Patient" combo box (number 147) I have two problems:
1) If a patient has ' in name (see O'Hanlon in example database) then I cannot select.
2) If patient has same surname but different forename I can only select one of them.
Probably very easy solutions but I'm stumped!
Thank you for any help.
Thanks for any help. See attached file.
First I know it's a crap database structure and I am endeavouring to change this. I am not a professional, just trying to set up a small database to help me look after patients.
On the "Select Patient" combo box (number 147) I have two problems:
1) If a patient has ' in name (see O'Hanlon in example database) then I cannot select.
2) If patient has same surname but different forename I can only select one of them.
Probably very easy solutions but I'm stumped!
Thank you for any help.