Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Forms with 1 to 1 relationships tables
Message
 
À
02/10/1996 19:49:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00009145
Message ID:
00009250
Vues:
38
>>>Hello, my name is Enrique Duhalt, and I'm new to
>>>Foxpro 3.0.
>>>I don't know how to create a form based on 2 tables
>>>related in a 1 to 1
>>>relationship.
>>>I tried it with a query (like in Access) but the
>>>assistant didn't let me
>>>do it.
>>>Can someone help me?
>>
>>if they are 1-1, the 'assistant' should be able to help...
>>
>>you'd wind up with 'select tablea.*, tableb.* from tablea, tableb where tablea.uniqueid = tableb.uniqueid'
>>
>>if they are 1-1, why would you use two separate tables?
>
>That's because not all the fields are going to be filled and I want to save some disk space.

that won't save disk space -- blank fields will still take the same amount of space...

>
>When I use the form wizard, If I select the other table then It erases the fields that I selected previously from the other table. I don't know what to do next.

i'd recommend combining the two tables. from there, you shouldn't have any problems...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform