D
Dennis
I am working with data that requires "many to one" tables.
I have one table that has a primary key that identifies
the people being tracked. I have many tables that will
track several appointments each person may have, including
the treatment, tests done, who performed the tests, and
other tables that cross reference alergys and other
important information. Before I get too far on this
project, what are the pitfalls I may run into if I do not
incorporate ??? into the design. Maybe the most common
mistakes made? (I'm sure I have already started making
some). I know this is a very broad question but whatever
guidance I could get will help,
Thanks,
Dennis
I have one table that has a primary key that identifies
the people being tracked. I have many tables that will
track several appointments each person may have, including
the treatment, tests done, who performed the tests, and
other tables that cross reference alergys and other
important information. Before I get too far on this
project, what are the pitfalls I may run into if I do not
incorporate ??? into the design. Maybe the most common
mistakes made? (I'm sure I have already started making
some). I know this is a very broad question but whatever
guidance I could get will help,
Thanks,
Dennis