On Nov 25, 2011, at 6:58 AM, Vineet Deodhar wrote:

> But in this case, pk's of 'category' and 'accounts' are fk's in 'employee'.

> And the chain of table-relationship is deeper than depicted in this

> simple example.

>

> Can there be any workaround for this kind of situation?

I'm not sure what the issue is. If you add the category bizobj as a child of the employee, and set its ParentLinkField to 'catid', when you select an employee, the related category record will be selected. Same would work for accounts.

This is standard relational database stuff. What is different about your tables that prevents this from working?

-- Ed Leafe

_______________________________________________

Post Messages to: Dabo-users@leafe.com

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/F9C1185E-2429-4E56-BA28-2B9430AC43E1@leafe.com