HOw to achieve the filter in front end

[sanjujeeboy]

Hi

I have two different fields from 2 different tables.

Traffic Dest	Traffic Arriv
EPG	EPG
PPG	CRT
TV	PPG

i want to create a filter in Front end named Traffic(as below) such that when i click on EPG in traffic, it should select EPG from Traffic Dest and EPG from traffic Arriv

Traffic

EPG

PPG

How to acheive this?

[Lisa_P · Accepted solution]

When you load this data, you can create a new field to indicate Traffic Type:}
Table1:
Load ....

   "Traffic Dest" as Traffic,

   'Dest' as [Traffic Type]

...

then in Table2:

Table2:

Load ....

   "Traffic Arriv" as Traffic,

   'Arriv' as [Traffic Type]

...