Results 1 to 4 of 4

Thread: Database Design Help

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Question Database Design Help

    Hai fellas
    I have few Master tables (say States, Districts, etc).
    Now when the proj loads for the first time, I collect the default values (eg the states which the user reqires).

    We need this info all through the session of the proj.

    What would be the best way to store these for future manipulations?

    I feel that it would be better if we have seperate tables to store defaults for each category.

    Could you confirm my assumption or provide a better alternative.

    Thanks in advance

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Database Design Help

    Quote Originally Posted by VBFnewcomer
    I feel that it would be better if we have seperate tables to store defaults for each category.
    This is the approach we use to store user defaults and program preferences. Using a table is nice for a number of reasons not the least of which is that settings and preferences "travel" with the user from machine to machine.

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: Database Design Help

    Thanks Hack.
    I'll wait for more inputs....

  4. #4

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: Database Design Help

    Hack,
    A lil more clarification pls.
    Do we store them in seperate table(s) as I said in OP or we can have a boolean field in the Master table and have a True/Check to denore the default ones.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width