Okay, its late in the day and I'm trying to get my brain around this...

I have a table of 6 products (they are software packages) each product can be had in 
several OSes and several versions, and two means of distribution.

Like this:

Product Name      |      OS      |      Version(s)  |  Distribution Type
    Product1    |    NT UNIX VMS  |  Version(s)  |  ESD CD
    Product2    |    NT UNIX VMS  |  Version(s)  |  ESD CD
    Product3    |    NT UNIX VMS  |  Version(s)  |  ESD CD
    Product4    |    NT UNIX VMS  |  Version(s)  |  ESD CD
    Product5    |    NT UNIX VMS  |  Version(s)  |  ESD CD
    Product6    |    NT UNIX VMS  |  Version(s)  |  ESD CD

I want to be able to store product name, all OSes chosen, Version numbers (as text) 
and either or both Distribution Types (depending on selection) so that I can recall 
the data later, like so:

Product Name      |      OS      |      Version(s)  |  Distribution Type
    Product1    |    NT                   |  1.1, 1.6, 1.8 |  ESD CD
    Product3    |    UNIX VMS       |  2.1.1            | CD
    Product4    |    NT UNIX VMS  |  5.0               |  CD
    Product6    |    NT VMS          |  5.6, 7.9        |  ESD

thoughts, comments, am I missing something obvious?

will
Webmaster
ALSTOM EMM
http://www.esca.com

----
William H. Bowen
Consultant,
CommonVision Corporation

425.739.3629 Voice


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to