Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird action when appending record to grid...
Message
From
24/11/2000 22:46:14
 
 
To
21/11/2000 23:29:03
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00444477
Message ID:
00445323
Views:
11
I have many One to many forms and the way to do work this is:
In the Data environment I set the relation (it doesn´t be One to many)
ParentTable---->ChildTable

Initial selected area: ParentTable

In the Form:
I put text boxes for ParentTable fields
In the Grid set the same relation than in Data environment but don't set to any Column a Field of the ParentTable

to insert a new record you can use this code:

Insert Into ChildTable(KeyField) Values(ParentTable.KeyField)
Thisform.Grid1.Column1.Setfocus

I hope this help
Be fast like the Fox
Be free like the Penguin
Se Rápido como el Zorro
Se libre como el Pingüino
Previous
Reply
Map
View

Click here to load this message in the networking platform