Hi

In my application I have 3 tables that are identical, but relate to different Parent Tables, they are called FAMILY, ASSESS_FAMILY and LACFAMILY - all relating to differnt Parents, but holding the same information.

Is it good practice to use 3 versions of 1 table, or is it better to use just one table, and have it multi-relational to different Parent Tables?

Any ideas appreciated.
Thanks
Kev