how to create one to many relashionship in Acces 2003

[SANEEHA]

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...

[drunkenneo]

While creating it Check the check boxes of Enforce Referential integrity and other checkboxes for to see the relationship.