Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add Relation Object in Form environment without Form designer

Status
Not open for further replies.

Xaplytz

Programmer
Jun 26, 2000
79
US
Hi
How add, delete, insert, deactivate and activate a relation objects in the data environment
when the from is running writing code instead of use the form designer.
Does someone have any Idea?

Thanks
 
HI

IF YOU ARE THINKING ABOUT CODE... SOMEWHERE, WHERE IT IS SUITABLE IN ANY OF YOUR EVENTS,

to create the realation....
SELECT myParentDBF
SET RELATION TO myFieldName INTO myChildDBF
** myFieldName is the common field name linking the parent and the child. Assumed the childDBF is set in that order of the linking field.

If yo are adding an additional relation to another DBF
SET RELATION TO myFieldName INTO myChild2DBF ADDITIVE

to delete the relation...
myParentDBF
SET RELATION TO

Hope this helps you :)
ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
 
I'm talking about add a RELATION OBJECT inside the MyForm.DB-environment by writing code.

not using the Form.designer and not user SET RELATION command.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top