Re: [sidcam] relating records on a List View page
Hey Sid,
If you're not comfortable with writing SQL, then you should use two getRecords(). One for each table. Here is a link to a similar situation with rentals and reviews:
http://www.interactivetools.com/forum/gforum.cgi?post=79374;search_string=list view joins;#79374
The second getRecords() needs a where condtion that uses the common field.
Something like:
'where' => 'companyid='.$contactRecord['companyid'],
Hope that helps,
Robin
Robin
Programmer
interactivetools.com