Hi,
For one of the sites that I maintain I am looking to create a form for adding hospitals including address and wards. The end aim will be to retrieve the data stored into another form in order to select a hospital name and then ward name in a double dropdown. What I can't decide in my mind is the method to save all the information into the database.
My initial thoughts are to have:
a single table for the hospital names
a single table to hold the address in separate columns
a single table to hold each of the wards one ward per column
These would all be linked by sharing the same "id" as the hospital so a query on a hospital would be able to select the additional attributes.
Any thoughts on setting it up this way or possibly a better or simpler way of doing it?
Regards,
Dave
For one of the sites that I maintain I am looking to create a form for adding hospitals including address and wards. The end aim will be to retrieve the data stored into another form in order to select a hospital name and then ward name in a double dropdown. What I can't decide in my mind is the method to save all the information into the database.
My initial thoughts are to have:
a single table for the hospital names
a single table to hold the address in separate columns
a single table to hold each of the wards one ward per column
These would all be linked by sharing the same "id" as the hospital so a query on a hospital would be able to select the additional attributes.
Any thoughts on setting it up this way or possibly a better or simpler way of doing it?
Regards,
Dave