> 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 For your perusal, the table structures are reproduced as under (just a sample)---emp: empid, acid, catid, empnm, dob, sex ac: acid, acnm, accd cat: catid, catnm, catcd How can "ac" and "cat" be childs of "emp"? Because pk's of "ac" and "cat" are fk's in emp. And, in this case, need is to select a category & see the employees in that cat. --- 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]
