• Well, a business key would not be something that you'd need to add to the parent table. I asked if you had one, meaning, is there a natural or candidate key already in your parent table.

    Can you post an example of your table DDL and a line or two from your text file (w/ column headers)?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden