Table Join to do this?

[crowden]

Hi,

Take a look at a profile page.

http://fwc.tolsdevelopment.com/inde...&fabrik__cursor=2&fabrik__total=19&tableid=22

How can I add to the bottom, a list of all projects that person is associated with?

In the Projects table, there are fields that contain names added from Profile page, so there is a relation.

 

[cheesegrits]

I think you'll have to do that by using a formbot and a tablebot on a static content page, and a custom 'detailed view' link which sets a URL filter for the Projects table.

So the detailed view link on the People table would need to point at the static content page, with this on the end ...

&projects_table___project_manager[value]={rowid}

The formbot would then just be ...

{includeFabrikForm form=13 editable=0}

{includetable table=X}

... where X is the table ID of your Projects table. The theory is that Fabrik will replace that {rowid} with the rowid in the URL, and the Projects table will then use that to filter on projects_table___project_manager accordingly.

Obviously change projects_table___project_manager to match the table and element name which joins from Projects to People.

If {rowid} doesn't work, try {rowpk}.

-- hugh