Table value lists help

[PRodgers4284]

Im have a table called "patients" and i have two fields within this table called "hospital" and "wards", i want to have a value list for each of these fields but i want when a user enters a hospital that the value list in the "wards" field changes to list all the wards within the particular hospital selected. Can anyone help me?

 

[JANR]

Check out cascading combobox. Here is one way: http://office.microsoft.com/en-ca/access/HA011730581033.aspx?pid=CH063650361033

JR

edit: This is done in forms and NOT in tables

 

[PRodgers4284]

Check out cascading combobox. Here is one way: http://office.microsoft.com/en-ca/access/HA011730581033.aspx?pid=CH063650361033

JR

edit: This is done in forms and NOT in tables

Hey thanks for that, i created two tables (Hospital and Ward) with a relationship and then created the form with the combo boxs, it works very well . Just wondering how i add the values selected in the combo boxes to another table uses the command button with the add function?

 

[Pat Hartman]

You need three tables to implement a many-many relationship.
tblHospitals:
HospitalID (pk)
HospName
etc.

tblWards:
WardID (pk)
WardName
etc.

tblHospitalWards:
HospitalWardsID (pk)
HospitalID (unique index fld1)
WardID (unique index fld2)