Collection Object

[Ruslan Zasukhin]

On 7/31/06 3:44 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

>>> My TC - this is table Central, and it play role of YOUR NSSet :-)
>> 
>> But it uses several records. I have to use only ONE record, that
>> points to several other records in several tables at the same time.
> 
>> One record in TC/NSSet is one instance of a collection object and
>> this instance/record has n pointers to other objects/records in other
>> tables.
> 
> I see now.
> 
> Wait. 
> 
> For case of 2 tables, we put pointer into MANY table. Right?
> So may be here we also should think in this way..
> Hmm, in this way hard...
> 
> 
> Well, then it seems you can use only next way
> 
> 
> In TC you make VarChar for example, and store data as:
> 
>     121355354,1545115,154321354,13564351356,
> 
> I.e. You make LIST of records with their OID values.

>> Yes, it definitely more hard and I don't see the advantage over an
>> M:M table so farŠ

Another way:

So we have 

    TC - on left side                    Few tables on right side

To link them we use special table:

                  --------------------------
                     intermediate table
                  --------------------------
                     RecID_TC   |    OID




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]