newmediaworlds wrote on Wednesday, October 31, 2012:
I need some help with OpenEMR. I’m trying to set a General Employers table for all patients in all clinics to retrieve a list of all patients per Employer. How can I do this?
bgregg wrote on Thursday, November 01, 2012:
How many unique employers are you working with? The reason I ask is this: It may be more efficient and easier to use the existing “Employer” tab of the patient’s demographics to hold that information. One thing you can do if you’re working with a small employer set (<20) to save time is to create a list with all of the employers, then change the Employer Name field to reference the list in Layouts, so there is no need to type the names- it just becomes a drop-down selection which will help eliminate any data entry errors.
That way there is no need to query two separate tables to produce your report, since it will all be housed in one.
Brad Gregg
Mi-Squared
newmediaworlds wrote on Thursday, November 01, 2012:
Thanks Brad!
I got it working. WOW I can’t believe how easy that was. On Admin I pressed Edit demographics and set the Employer Data Type to a List Box on the Group. Then I created a custom List called Employer and added all the needed Employers to the list!
Thank you.