On Nov 24, 2011, at 5:24 AM, Vineet Deodhar wrote:
> I have MySQL tables like this:
>
> emp (CHILD table for 'employees'):
> empid, acid, catid, empnm, dob, sex
>
> ac (PARENT table for 'accounting info'):
> acid, acnm, accd
>
> cat (PARENT table for 'category'):
> catid, catnm, catcd
>
> While creating bizobj for child table "emp",
> would DABO support defining multiple 'LinkField' properties?
> (pl. see the * mark below)
> [CODE]
> class EmpBizobj(dabo.biz.dBizobj):
> def afterInit(self):
> self.DataSource = 'emp'
> self.KeyField = 'empid'
> self.NonUpdateFields = ['empid']
> self.AutoPopulatePK = True
> * self.LinkField = 'acid'
> * self.LinkField = 'catid'
> [/CODE]
>
> If multiple 'LinkFields' is not supported , then how do I define
> multiple parents for a child?
That seems like a backwards design. In any database structure I've
created, the 'ac' and 'cat' tables would be the dependent in the relation;
i.e., their values depend on the employee that is selected.
-- 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]
