Greg,

Here's a gist of the table structure -

[Source Table]

{Id}{Name}{Addr}{City}{State}{Zip}{Item}{Qty}

[Destination Tables]

[Master table]

{Id}{Name}{Addr}{City}{State}{Zip}

[Detail table]

{Id}{Item}{Qty}

Many Thanks!

sorry i put DTS in there - i'm open to any suggestions.

Thanks,

Adi