i have three tables in access:
Hospital
Doctor
patient
I nedd to creeate one to many relashionship between :
hospital and ptient
and
hospital and doctor
When ever i create relation ship between the primary key of hospital and the same key as foreighn key in patient table, the relation ship window soesnot give any option of one to many relationship...
please help...