I was about the same way. Not knowing the modern database I did not answer. However, what you are describing is something similar to the ARRAY(x,y,z,x1,y1,z1,.......xn,yn,zn) or any other way you would like to describe the subscripts. But, it allows only one value after using all the subscripts. BUT you can build one array that will have for colour that has a subscript value to go to the next array.
Might become complex. Chris > Jacob, > > First of all, I want to say, "Damn you!". I was just about ready > to > turn in for the night when I read your post. Now you got me thinking > and I'm going to be up later than I wanted. :) > > My suggestion: If you want 6 dimensions, you should have 7 tables. > > One each that is a simple list of the possible attributes along that > dimension, e.g. Make Dimension: Ford, Chevy, Chrysler, Toyota, etc. > Color Dimension: Blue, Red, Silver, etc. Then your seventh table will > simply have 6 columns with tuples for each combination that exists -- > the boolean ones. <Ford, Red, 1998, etc..>. > > Where it gets interesting is when you want to display the data in > tables. Especially if that is supposed to be interactive. > > I would suggest you look at a browser-based approach. Probably > PHP, > but I know very little about that. You would want to construct a > program that would loop over the x,y that you chose and construct a > table with X's in the cells that would contain boolean ones. The X's > would actually be hyperlinks to start the process over again with > different query criteria. > > I can vaguely imagine how you could do something like this, but I > don't know the actual tools well enough to do it myself. You could > also program something like this from scratch, but I believe a > PHP/browser approach would give you faster results easier. In any > case, the display/selection bit is probably beyond what you can do > with off-the-shelf database form/table tools. Although you could > easily set up the forms to input the data I suppose. That could save > you some work. > > Hope this helps. Interesting problem -- check back here, I would > like to hear what you come up with. > > Rod > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] For > additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
