Counting related records

[Ruslan Zasukhin]

On 6/3/05 9:14 AM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:

Hi Kem,

> I have a M::M BinaryLink between tables T1 and T2. For every T2 record, I
> want to get a count of the records that it's linked to in T1. Is there a way
> to do this in VStudio?

Yes, Using SQL query

Please look into Valentina_SQL_2_en.pdf

Section "Link Functions"

Exist function as count_linked()

So you can do query similar to:

    select *, count_linked( link_name )
    from T2



-- 
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]