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

[Olaf Schmidtmann]

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
>