alright so I told someone i'd help them fix their existing database. the database is set up incorrectly.
is there any way of fixing this database to show multiple pregnancies and changing the database around without needing a major overhaul. i understand how it should be set up with the PREGID as the main table and the womanID as the foreign key.. but they already have hundreds of women in the database.
not sure what to do

img543 DOT imageshack DOT us/img543/6497/preg DOT png
is there any way of fixing this database to show multiple pregnancies and changing the database around without needing a major overhaul. i understand how it should be set up with the PREGID as the main table and the womanID as the foreign key.. but they already have hundreds of women in the database.
not sure what to do
img543 DOT imageshack DOT us/img543/6497/preg DOT png