On Tuesday 07 October 2008 05:06:30 pm Mike Mabey wrote: > On Tue, Oct 7, 2008 at 5:44 PM, johnf <[EMAIL PROTECTED]> wrote: > > On Tuesday 07 October 2008 03:42:07 pm Mike Mabey wrote: > > > parts`.`name` > > > > Does the parts table or parts bizobj contain a field with 'name' as the > > field > > name? I ask because you snipped some of the fields. > > > > -- > > John Fabiani > > No, it doesn't. I only snipped what wasn't relevant to the problem at > hand. And in case it helps you understand my situation, another feature of > the `categories` table is that the `name` field is unique, so the ratio of > indexes to names in that table is 1:1. This was on purpose so that joining > wouldn't result in not being able to map back to the fk value. > > Mike M.
This sounds like a parent ->child situation - is that right? I wouldn't use the join. I'd use the parent->child Dabo code available. The categories table has the FK into parts. So add the following to categories bizobj. self.LinkField = "index" self.ParentLinkField ="parent_category" self.FillLinkFromParent = True partsBizobj.addChild(catsBizobj) This should allow you to set the datasource and datafield to categories, categories.name in a normal fashion. -- John Fabiani _______________________________________________ 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]
