This topic is locked

Master / child / s/child issue

10/18/2008 8:33:46 AM
PHPRunner General questions
F
frphilip author

Hi,
I've got 3 table :

  • company
  • managers
  • contacts
    One company can have several manager, and each manager can be contacted several times.

    The relations are company.societeID to managers.societeID , and managers.contactID to contacts.contactID.
    The sql request configured in PHPR are :

    LEFT OUTER JOIN managers ON company.societeID = manager.societeID
    and
    LEFT OUTER JOIN contacts ON managers.contactID = contacts.contactID
    I've one company, with one manager and 4 contacts.
    Il the list page for company, I can see 4 rows for managers in the preview for child record. But I've only one manager for thes company ! so, why company list take the 4 contacts ?
    I tried to group in the SQL, with no better result.
    I'm with 5.0, test mode. Nice tool <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=9881&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
    Thank you for your replies.

Sergey Kornilov admin 10/18/2008

frphilip,
it's hard to understand what you asking.
Is that bout how to implement something or you already built a project and it doesn't work the way you need it to work?