Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Forms with 1 to 1 relationships tables
Message
From
02/10/1996 19:49:04
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00009145
Message ID:
00009198
Views:
39
>>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.

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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform