[SQL/V4MD] best way to link one record to multiple categories?

[Mathew Ray]

Thanks Olaf,

In this example, if I had N categories, the additional table would need N
columns, correct? Basically it would build a sort of look-up table for every
record? Wouldn't I also need to index every field so that I can find
associations from any table's record to any other record?

Thanks,
Mathew

----- Original Message -----
From: "Olaf Schmidtmann" <os at brainbits.net>
To: "'Valentina Developers'" <valentina at lists.macserve.net>
Sent: Thursday, January 30, 2003 1:04 PM
Subject: RE: [SQL/V4MD] best way to link one record to multiple categories?


> Hi Mathew,
>
> what about the classic: using an additional table with two fields.
> table_A_RecID | table_B_RecID
> Should do the trick. I'd not advise using lists in fields and loop them.
> Mrs. Valentina is much faster.
>
> greetinx
> Olaf
>
> --
> Olaf Schmidtmann
> brainbits
> online & cross media
> mailto:os at brainbits.net / www.brainbits.net
>
> > -----Original Message-----
> > From: Mathew Ray [mailto:mathew at iqtv.com]
> > Sent: Thursday, January 30, 2003 6:56 PM
> > To: Valentina Developers
> > Subject: [SQL/V4MD] best way to link one record to multiple
> > categories?
> >
> >
> > I was thinking about this recently and I know it will
> > eventially come up in
> > one of my projects... I've done this in Coldfusion using
> > multiple queries,
> > but I am unsure about the process in Valentina/Director.
> >
> > What is the best way to associate one record to multiple
> > related recIDs in
> > another baseObject? Store a list of recIDs inside the field
> > and then loop
> > through that? Or, is there a way to have some sort of
> > table-within-a-field
> > functionality?
> >
> > Just curious,
> > Mathew
> >
> >
> >
> > _______________________________________________
> > Valentina mailing list
> > Valentina at lists.macserve.net
> > http://listserv.macserve.net/mailman/listinfo/valentina
> >
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
>