On Oct 27, 2005, at 1:24 AM, [EMAIL PROTECTED] wrote:
I forgot to mention the other way to join tables, by setting a
parent/child
relationship among one or more bizobjs. Please ask and Ed or
myself will go
into detail on that...
Please could you do that. Paul's explanation of overriding the
base SQL was
very clear.
You can set a relationship between bizobjs (and thus the tables
they represent) by setting a couple of properties on the child:
LinkField: set this to the name of the foreign key field that is
linked back to the parent table.
ParentLinkField: if the field in the parent table that determines the
child is *not* the PK, set this field to the name of the field that
is linked to the FK in the child. Most of the time, though, you will
not need to set this.
Then just let the parent know it has a child by calling
parentBizobj.addChild(childBizobj). From then on, anything that
changes the record in the parent bizobj will automatically requery
the child to get the corresponding records.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
