General information
Category:
Coding, syntax & commands
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only