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.
|
|