>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
If different Family data will always need to remain consistant in the fields/data stored, then I would use one table (easier maintenance in the long-term).