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 Leafe
_______________________________________________
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]
