Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: Database Structure problem

    Let's say I have blue widgets and red widgets in two different tables. Then I have a Sold table. How should I set the Sold table up so that I have the BlueID's and RedID's in the table. Two different columns? One column that could contain both values? Or a seperate categoryID that links to a table that describes the different widget categories?

  2. #2
    Join Date
    Jan 2003
    Paris, France
    You can have something like this

    A field that mark is the records is from blue or red
    Olivier Miossec

Posting Permissions

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