#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    2
    Rep Power
    0

    Tables design and relationships to one table


    I heard in financial systems tables design where there are many sub headers before the entries are made, the designs involve one major table for all headers maybe upto the entry level where records are assigned oarent id column and headers column. How can i do this for my own here [IMG]aasoftwares.net/zastructure.jpg[/IMG] AND how can it be Queried on a report as shown also on left side of that image.

    thanks..
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,120
    Rep Power
    4274
    this may help -- Categories and subcategories
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    2
    Rep Power
    0
    thanks..i will check that

IMN logo majestic logo threadwatch logo seochat tools logo