Filter applied to two different tables

[Paulonst]

Hello,

I have the following data model and I would like to have a filter in the app that should be applied to table ZPP_PRODUCAO_I.Fábrica and also to ZPP_DESPERD_B.Fábrica.

What is the best solution?

Thanks in advance for your time.

[Anil_Babu_Samineni]

Did you used few of the fields by ref of "QUALIFY"? If o, Why it is necessary?

[Paulonst]

Sorry but I couldn't understood your question.

[Anil_Babu_Samineni]

My question : Does all tables are pulling from different tables?

My suggestion : Change ZPP_DESPERD_B.Data this field with Data as per ZPP_PRODUCAO_I and see if that associate doing properly or not?

[Paulonst]

Yes, all tables are pulling from different tables.

I tried before that association with Data and it doesn't work, that's why I've created the MasterCalendar table.

[rwunderlich · Accepted solution]

You should probably concatenate the two tables into a single table. 

Concatenate (ZPP_PRODUCAO_I)
Load * from ZPP_DESPERD_B source...

-Rob

[Paulonst]

I was trying to create some sort of relation between the tables, but your sugestion solved my problem.

Thanks @rwunderlich  and @Anil_Babu_Samineni