In VFP 5.0a, working in a local view, I am showing a list of patients from a medial record database with the
following columns:
cFirstname,cMiddlename,cLastname,cChartNumber,PHYSICIAN
PHYSICIAN is just a reference for the user, so I actually build the physician's fullname by calling a routine I
wrote, BuildFullName:
buildFullName(Physicians.cFirstName, Physicians.cMiddleName, Physicians.cLastName, Physicians.cSuffix)
AS PHYSICIAN
I store only the primary key of the physician in the patient record, and then use a left outer join to get the
above result. However, I keep getting the error:
Field PHYSICIAN does not accept null values.
because some patient's don't have a physician assigned to them yet. Is there anything I can do in the syntax to
force this calculated field to accept null values? I'd rather not change my BuildFullName() routine to return
"N/A" or whatever.
Thanks.