• Hey Root,

    What Toby said above looks right at a glance, but I believe the problem is more basic for you. You've misunderstood, or haven't been informed, of some basic principals of database design.

    You want to look into 'normalization'. There are about a billion articles on the web, but in essence you're repeating data. In specific look up information on 1st normal form, 2nd normal form, and 3rd normal form. You want to aim for 3rd normal in most circumstances unless you have specific reasons to avoid it.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA