At first I had one table, District# (Pkey) and HCFirstName, HCLastName, HIVFirstName and HIVLastName.
The HC person could also be the HIV person.
I broke the table into two. Both with primiary keys as District#.
For mailing labels you could draw on either of the tables. Now the problem is that when the HC person is the HIV person, you get two labels, one from each report.
What is the best way for me to approach this?
I am considering adding a field back on the "big" table that I did not delete yet to include HC, HIV, or BOTH as its field value and then separating one large query by this value.
I think it is the best way to go. Can you tell me if this is correct? OR is there another way to go?
The HC person could also be the HIV person.
I broke the table into two. Both with primiary keys as District#.
For mailing labels you could draw on either of the tables. Now the problem is that when the HC person is the HIV person, you get two labels, one from each report.
What is the best way for me to approach this?
I am considering adding a field back on the "big" table that I did not delete yet to include HC, HIV, or BOTH as its field value and then separating one large query by this value.
I think it is the best way to go. Can you tell me if this is correct? OR is there another way to go?
