Can someone please help me with a query? I’m trying to pull a report of patient info, like name, address , etc but I need to include values from a specific USER-DEFINED Patient Field. How would that be written? (Patfielddef and fieldname in there somewhere?)
Thanks!
Help w/query that includes user-defined field
Re: Help w/query that includes user-defined field
can anyone give me the values so i can plug them into my query??
thanks!
thanks!
Re: Help w/query that includes user-defined field
The patfield table contains all the info you need to add to the patient table for the report you want. The fields that you may need are patfield.FieldName, patfield.FieldValue and you can use patfield.PatNum as a link to the patient table. If you have more than one patient field defined, then you will need patfield.PatFieldNum.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
Jorge Bonilla DMD
Open Dental user since May 2005
Open Dental user since May 2005
Re: Help w/query that includes user-defined field
thanks, that's the missing link for me to try to cobble this thing together. as always, thanks jorge!!!!!!!!!!!