
Announcements
I have 2 data verse tables the first table 'table1' have a lookup column to the table2 named parent id
and I want to filter the table2 based on the lookup column
Filter (table2,'table2id' in Filter (table1, my filter based on other columns). parentid.id)
but I can't get this work if anyone can help me
Hi @mf123 ,
I did a test that I think is what you are trying to do here where I have a table called Header and a table called Child where I have a lookup on the Child table back to the Header. I am filtering the child information based on the selected Header record in the gallery.
Filter(Children,Header.Header = Gallery1.Selected.Header)