I'm creating an Access app for a doctor's office, and am stumped on how to structure my query...
It starts with a form for new patients -- enter the patient's name, etc., -- and the form has a list box to choose how the patient was referred. Must be able to check off multiple items.
The only other requirement is a chart that shows how many times each referral source was checked.
So here's what I need to figure out...
1. When I add the list box to the form, how do I relate the list box data to the patient ID?
2. How do I form a query that will show A) a list of all of the referral sources, and B) a count of how many times each one was selected?
In case it helps, here are my table and field names:
Fields: ID, PNAME, DATE
Foreign Key Field: FK_REFERRALS
Fields: ID, RNAME
Thanks -- offering 500 points since there are two parts to my question.