M
magicdds-
I have a table that has lots of patient information. I have a second table
that has diagnostic information about each patient. The tables can be linked
in a query (one to many relationship).
I need to take each of the entries in the Diagnostic Information table for a
specific patient and make it into its own field in a single record, for a
particular patient.
For example:
PATIENT TABLE:
PatID Patient Address City State
1 John 22 Main St. AnyTown PA
2 Tim 234 5th Ave. Hometown PA
DIAGNOSTIC INFORMATION TABLE:
PatID Type Appliance
1 Fixed Appliance Upper Braces
1 Fixed Appliance Lower Braces
1 Removable Biteplate
2 Fixed Appliance Upper Braces
2 Removable Upper Retainer
2 Removable Lower Retainer
2 Removable Headgear
The new table or query produced should look like this:
PatID Patient Address City State UpperBraces Lower Braces etc
1 John 22 Main St. AnyTown PA yes yes
2 Tim 234 5th Ave.Hometown PA yes no
There is not enough room to demonstrate, but the field names at the top of
each column in the new query or table should be:
PatID
Patient
Address
City
State
Upper Braces
Lower Braces
Biteplate
Upper Retainer
Lower Retainer
Headgear
I was wondering if this is possible because I need for each of these columns
to be a seperate mergefield into WORD. Also, the table cannot be pre-setup
by me because each doctor that I give the program to will enter his own list
of diagnostic information to incorporate into his letters. One doctor may
have a list of 10 choices that his receptionist can select from and a second
doctor might have 30 choices that his receptionist can select from, when
entering patient information for each patient. I want the doctor, on the
initial setup of his program to enter his list of 10 or 30 Diagnostic choices
in a form and then the form should create a new table that will accept and
hold the diagnostic choices for each patient in a single record, or a query
that will take multiple records of diagnostic information, for a single
patient, and combine them into a single resulting record for a mail merge
(the mergefields must always have the same names so that the Word Document
with the mergefields, once created, can be used at anytime, for any patient).
I beleive that this is possible, in that I have seen it work in other
programs. I just have no idea how to do it. Can anyone help me figure this
out?
Thanks,
Mark
that has diagnostic information about each patient. The tables can be linked
in a query (one to many relationship).
I need to take each of the entries in the Diagnostic Information table for a
specific patient and make it into its own field in a single record, for a
particular patient.
For example:
PATIENT TABLE:
PatID Patient Address City State
1 John 22 Main St. AnyTown PA
2 Tim 234 5th Ave. Hometown PA
DIAGNOSTIC INFORMATION TABLE:
PatID Type Appliance
1 Fixed Appliance Upper Braces
1 Fixed Appliance Lower Braces
1 Removable Biteplate
2 Fixed Appliance Upper Braces
2 Removable Upper Retainer
2 Removable Lower Retainer
2 Removable Headgear
The new table or query produced should look like this:
PatID Patient Address City State UpperBraces Lower Braces etc
1 John 22 Main St. AnyTown PA yes yes
2 Tim 234 5th Ave.Hometown PA yes no
There is not enough room to demonstrate, but the field names at the top of
each column in the new query or table should be:
PatID
Patient
Address
City
State
Upper Braces
Lower Braces
Biteplate
Upper Retainer
Lower Retainer
Headgear
I was wondering if this is possible because I need for each of these columns
to be a seperate mergefield into WORD. Also, the table cannot be pre-setup
by me because each doctor that I give the program to will enter his own list
of diagnostic information to incorporate into his letters. One doctor may
have a list of 10 choices that his receptionist can select from and a second
doctor might have 30 choices that his receptionist can select from, when
entering patient information for each patient. I want the doctor, on the
initial setup of his program to enter his list of 10 or 30 Diagnostic choices
in a form and then the form should create a new table that will accept and
hold the diagnostic choices for each patient in a single record, or a query
that will take multiple records of diagnostic information, for a single
patient, and combine them into a single resulting record for a mail merge
(the mergefields must always have the same names so that the Word Document
with the mergefields, once created, can be used at anytime, for any patient).
I beleive that this is possible, in that I have seen it work in other
programs. I just have no idea how to do it. Can anyone help me figure this
out?
Thanks,
Mark