• It looks to me like Customer and Person data need to be separated in this, to make it work well.

    I'd be willing to be that "name" and "age" really belong in a "People" table.

    Normalizing the data that way will make everything you do with it easier.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon