help with creating data restrictions

[aburaed]

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!

[pbaldy]

If the form is in single view, this type of thing:

Baldy-Cascading Combos

[Waldenbound]

You could have a lookup table with the following fields: ID number, hospital, ward number. The ID number would would be stored in your main table (under the hospital field) which would relate to the ID in the new lookup table for the details. Then in your form you could use a multi-column combobox that allows the data entry person to select the Hospital and ward in one selection from the lookup table and store the ID in your main table. Or, if there are too many combinations for the combobox you could still use cascading combos.

[aburaed]

thanks,
yeah there are many wards and hospitals and many combinations.
im going to give this cascade combo a try, but aaa! visual basic is new to me.