Well that sure din't format too good. hope you get the idea.... >You really wouldn't want to break them into individual columns, because >then if you needed another value you would have to change your table to >accomodate it. You want to add a row for new values. As Bryan says you >need a many to many table to join them. For example, a car could have >many colors and a color could be used for many cars so the following: > > Model_Table Model_Color_Table Color_Table >Model ID ModelID ColorID ID Color >Ford 1 1 1 1 Blue > 1 3 2 Green > 3 Red >Would show we have a blue and a red ford. Using this method you >can add as many models or colors as desired and simply join them >using the Model_Color_table. > >> Can you tell me what developers generally use as alternatives? Should >> I break the values into individual columns? Thanks for your advice! >> >-chris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203593 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54