Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to construct this View ?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How to construct this View ?
Divers
Thread ID:
00110086
Message ID:
00110086
Vues:
47
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform