Last post Jul 10, 2010 10:15 AM by sjnaughton
Jul 09, 2010 05:40 PM|raphaelp|LINK
I want to search on a present value in a field of a foreign table (three related).
Here is the structure of my database:
Table1 <- (1 )---------( 1) -> Table2 <- (n )--------( 1) -> Table3
On the "Table1" I want to have a filter (text) on a field in the Table3.
I use DynamicData 4.
Jul 10, 2010 12:12 AMfirstname.lastname@example.org|LINK
you can use
Select our field name from Table1 inner join Table2 on
Table1.ID= Table2.Id inner join Table3 on
Jul 10, 2010 10:15 AM|sjnaughton|LINK
I would have a look at the DD4 Preview is you have the code if not it is here on my SkyDrive
DynamicDataPreview4Refresh.zip in paticular have a look at the many to many filter (I know it's not a many to many but the filter
could be adapted to do it) [:)]