1 Reply Latest reply: May 22, 2012 6:08 AM by Darius Pranskus RSS

    Table with independent columns

    Darius Pranskus

      Hi

       

      I am wondering, is it possible to create a QV table, whose columns are independent? It would be used for various selectors. Now I am using island tables for each selector, but it would be nice to have one table for all selectors, having each as separate field. It will reduce the overall database model. Model looks not elegant when there are many island tables with just one field in them.

       

      I can join all these selector tables together, but in this case lots of rows are generated by cross join.

       

      What approach do you use for that? Maybe there is simple and elegant approach.

       

      Thank you very much

       

      Darius.