So I have 6 tables: Doctors, Drugs, Health Plans, Patients, Refills, and Rx.
Doctors have fields of ID (primary key), Doctor ID, First Name, Last Name, and Phone
Drugs have fields of UPN (primary key), Name, Generic, Description, Unit, Dosage, Dosage Form, Cost, and Price/Dosage
Health Plans have fields of ID (primary key), Plan ID#, Plan Name, Address, City, State, Zip, and Phone
Patients have fields of Patient ID (primary key), first name, last name, phone, date of birth, gender, health plan, and allergies
Refills have fields of ID (primary key), prescription id, and refill date
Rx have fields of prescription id (primary key), UPN, quantity, unit, date, expire date, field7, auto refill, refills used, instructions, id, and doctor
I just need help since I'm new to access and the professor hardly even taught any of this. I'm struggling to find relationships for tables of patients, drugs, and health plans. Thank you!