Hi. This Newbie is hopelessly confused.
Trying to build a simple database of my medical appts. Two tables:
The "one" side:
Providers table: name address phone, etc. (At the moment, has 13 records in it.)
The "many" side:
Appointments table: Date, time, etc. (At the moment, has 3 records in it.)
Relationship: for the first several tries, the relationship status was "indeterminate". Finally figured that out and "Relationships" now properly shows one-to-many. Primary key in "Providers" is ProviderID which becomes a foreign key in Appointments.
But when I use the Query Wizard, include both table and all fields within both fields, no records are selected.
I asked about a form that would include all info the other day, but then figured out that if the query isn't working first, the form never would!
Please, can someone help me figure out where to begin?