On Tue, Apr 22, 2008 at 9:54 AM, Ed Leafe <[EMAIL PROTECTED]> wrote: > On Apr 22, 2008, at 10:46 AM, Paul McNett wrote: > > >> I am using a mysql database. The PersonID is a foreign key field in > >> the database. For lookup purposes, I want to create a customers > >> bizobj that joins both tables by the PersonID field. My question is > >> with new insertions. If I call bizobj.new(), I would like it to > >> create a new entry in each table. Is that possible using the one > >> bizobj in this configuration? Will the personID field be filled in > >> the Customers table automatically? Right now I have 2 separate > >> bizobjs but would like to condense it into one. Thanks. > > > > I am unclear on how to handle this type of 1:1 table relationship > > simply > > and elegantly also. > > This should be set up with Person as a child of Customer, with > Customer.NewChildOnNew = True, Person.NewRecordOnNewParent = True, and > Person.FillLinkFromParent = True. Then when a new Customer is created, > a matching and linked Person record is created.
Ed, I understand that and do what you suggested currently. My question is why can't I do it with one bizobj that uses a join to join the tables together? Nate L. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
