Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Elementary question - display parent field on child's fo
Message
From
02/03/2000 10:53:37
 
 
To
01/03/2000 19:09:56
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00340197
Message ID:
00340560
Views:
29
Actually, I do this all the time. All you need to do is create a view with the child information linked to the parent table and select the field you want to display (and obviously also all the fields you need in the child table). Then base the form on the view, the data from the parent table is now included in the view because they are linked by the SQL, so you don't have to monkey around with the wizzard form code at all, it automatically updates. Also this way when the client caomes back and says "Oh we need this field too", you only need to include the field in the SQL, and add it to the form.

Try it you'll like it.

John
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform