Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Forms with 1 to 1 relationships tables
Message
 
To
02/10/1996 14:17:07
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00009145
Message ID:
00009147
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform