Search results

Thank you for your excellent advice. I'm feeling my way by trial and error, and your tips will be invaluable for improving my database design!

If I understand correctly, I am trying to update the Mothers table with a field from the Unique_Mothers query, not the other way around. Would it still require the Unique_Mothers query to be updateable?

I've got as far as step 6. Unfortunately when I try to run the UPDATE query, I get an "Operation must use an updateable query" error. Please refer to the attached screengrab. I've attached the sample database too. When trying to figure out what this error is, I came across this page...

plog: thank you so so much!

That's brilliant! "Twin 1", "Triplet 3" etc is so much more concise and elegant than my redundant "of X" part! Excuse my ignorance, should I post a zipped .accdb file with structure and sample data as an attached file?

Mother.NRIC: this should be unique, but I also understand Uncle Gizmo's point. Birth_Order and Delivery_Order: Thanks. Would it be possible in multiple births, for it to display "Twin 1 of 2" or "Triplet"... depending on how many births are recorded for a particular delivery? Baby.NRIC: These...

Hi all, I'm trying to split a table up because I now realize it won't be able to do what I need in the future. It wasn't designed properly at the outset, and I'm trying to correct it now, and any suggestions would be gratefully received! This is a database of pregnancies and deliveries. The...