Susan Harkins
ssharkins at gmail.com
Fri Aug 29 08:07:25 CDT 2014
I'll spend the morning rereading the book Martin and I wrote, brushing up on the normalization part. I've forgotten a lot of the basics. I'm writing an animal tracing database in Access and I'm trying to remember if it matters where the fk goes. Now, I remember its purpose and all that, but it would be so much simpler if I could just drop them all into the main table instead of adding a fk to all the child tables to the main table -- I think anyway. So, I've got a main table of animals and all of the remaining tables are child tables of a sort and a few lookup tables. Is it reasonable to just add a fk to all those child tables in my parent table? I just don't remember. I haven't built a database in... seriously... 10 years? It's been long enough that I'm really struggling. Susan H.