hi, all, i'm a rookie and hoping for someone to steer me in the right direction.
i'm designing a database based on a paper form we use to keep track of the total number of patients every month at several hospitals and wards.
On our questionare:
Hospital:
Ward:
Month:
A Hospital could have many wards, and I would like to restrict the choices of ward for the data entry person to only be those related to the hospital they select.
for example: Hospital A has a burn ward, a NICU ward and an ER ward.
Hospital B has ward #1 and ward#2.
How can I create the database so that a dataentry person would only be able to select ward #1 or ward#2 if they selected Hospital B?
thanks for the help!