Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to construct this View ?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How to construct this View ?
Miscellaneous
Thread ID:
00110086
Message ID:
00110086
Views:
46
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,
José Augusto Cavalcanti
Global Connection
jose.cavalcanti@globalconnection.com.br
Next
Reply
Map
View

Click here to load this message in the networking platform