> 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 ================================================== Ed, In this case, what would you do (considering yourself in my shoes)? In employees table, we have to link employee record to a category & also to a financial account. Regards, Vineet
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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]
