Re: Data Dictionary

You would probably have a Clothing table, a Color table, and a middle table that relates the two if the number of colors is variable.

The middle table may have the following fields:

ClothingRef (links to ClothingID)
ColorRef (links to ColorID)

If there is a practical maximum of colors, then it may make things easier to have Color1, Color2, Color3......in your clothing table. Some complain about this approach from a theoretical point of view, but it often simplifies things if you are under pressure to get it done (RAD).

-tmind-

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!