Hello everyone,
I'm very new to Access and I think I have to make a major change to a table. I have attached a pic of my relationships. I think I need to add the SpecialtyID field (Specialty table) to the Referrals table.
I know to use an Append Query. But I'm unsure how. There are over 1000 doctors to apply the SpecialtyID to in amost 7000 records. I want to make sure the correct SpecialtyID matches up the the correct DrID.
I could really use some help.
Thanks,
Don
I'm very new to Access and I think I have to make a major change to a table. I have attached a pic of my relationships. I think I need to add the SpecialtyID field (Specialty table) to the Referrals table.
I know to use an Append Query. But I'm unsure how. There are over 1000 doctors to apply the SpecialtyID to in amost 7000 records. I want to make sure the correct SpecialtyID matches up the the correct DrID.
I could really use some help.
Thanks,
Don