Hi 

You may have had this qustion before, so apologies if I have not found an answer !! 

I have  a table one which iss et that the user can click a url page link to a second table 'remembering' a formID he sees alongside the link. When the second table onpes he puts in the IF and the form populates. Now both these forms could even be on the same page .; However what is needed is a way to capture the Form ID from the first table and let it 'see'd a var variable in the second table that would set the filter. A couple of views are attached labelled form one - form two 

MAybe a bit of extra code ? - I am sure this would be useful to many ( Invoice header- line details for instance)

Best 

Richard

PS - Really getting around the tables and your plugin is awesome!!

Hi Bogdan

Sorry for the delay in reply

FormID is the column name for the common foreign key bewteen the two table. 

"As I understand you want when the users click on some cell/link from the 1st table, that link will go to the other page where 2nd table is and based from the chosen cell from the 1st table, the 2nd table will be filtered"

This is exactly what I am looking for however the chosen cell in the first table is the hyperlink. the foreign key is just a column beside it !

I am posting a completely different question seperately that is gicing me a headache !!

Richard

No Problems - I found a work around - however it has a problem !!

In the back end I create an Insert trigger that sets up a url as follows

http://form-narrative-old-forms/?wdt_column_filter[FormID]=2396

In image attached for Table 2 you will see that this works just fine.

However I have a second page to do something similar 

http://mages-old-forms/?wdt_column_filter[FormID]=2396

and you can see from Table 1 image the filter is not working - any ideas ??

Richard

Hi Bogdan

Nope were on 2.3 - however have now upghdared ! - Thanks for that

Your link worked first time and I can see filters set in the columns , however when I tried this

http://imagedev.regencysociety.org/images-old-forms/?wdt_column_filter[FormID]=1172

No filter is set in Column FormID.

Rechecked - Name can filter,JGC_N0 can filter but not FormID so has to be something to do with the column settings??

FYI The column name has not been changed  in WP Tables from the back end column name

Strange !!

Richard