>Hi,
>
>I have an "Attentions" Table that has 3 child tables "Telephones", "Faxes" and "Emails" where the user can include any number of them. I want to create a View with some "Attentions" information and "the first 2 occurences of each child table". I mean, if an "Attention" has 3 "Telephones", 2 "Faxes" and No "Emails", the View result should looks like :
>
>Attention´s Name Tel 1 Tel 2 Fax 1 Fax 2 Email 1 Email 2
>John 123-4567 456-7890 098-7654 765-4321
>
>Is it possible ?
>
>Regards,

Something like...

select top 2 this,that from file1,file2 where fk = id order by this,that

This will select only the first 2 records of the this,that order...

Not sure if this is doable in the view designer... you may have to write the sql manually.

BOb