Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2004
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Table Help (2000)

    I am creating a new database for our Tax Department. I have most of the tables set up, but am having trouble deciding how to set up one part of the database having to do with the different types of Plans.

    Below are two of my tables the problem lies with the Plan Type:

    tblPlan | tblPlanType
    ------------ | ----------------
    PlanID (PK) | PlanTypeID (PK)
    PlanName | PlanType
    PlanTypeID
    PlanContactID

    Under Plan Type, I have two Plan Types that will have several choice and the user will check all that apply to the Plan i.e.:

    Plan Type = NQDC and under NQDC, the choices are Salary/Standard Bonus/Performance Bonus/ Other Compensation, etc.

    How do I work the choices in to the Plan Type for the two that will have this? Would they be two separate tables?

    Thanks
    Nadia

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table Help (2000)

    If you want to apply the normalization rules strictly you should have a third table.

    tblPlan | tblPlanType | tlbPlanSubType
    ------------ | ----------------|--------------------
    PlanID (PK) | PlanTypeID (PK) | PlanSubTypeID
    PlanName | PlanType | PlanSubType
    PlanTypeID | | PlanTypeID
    PlanSubtypeID
    PlanContactID

    Now if you are speaking of two plan types and 4 or 5 sub plan types, I could accept a two table scenario.
    This would make the plan type table 8 or 10 records to select in a combo. Not a big deal.
    Maybe others would reject this.
    Note that this could be a huge amount of work to reverse to a three table scenario if in the future you want to add other plan types.
    Francois

Posting Permissions

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