auto select same value in tow table

[ghassanaldalati]

I Have to Source of Data ( CN & MP )

and both source sharing with some heading 

CN Invoice Date   with   MP Invoice Date

CN Cust_ID           with    MP Cust_ID

how can I auto select same value in  (MP Cust_ID) when I choose vale from (CN Cust_ID) 

[qlikwiz123]

Looks like those two tables are not connected at any level. Make sure you connect those in the script so that it creates an association. That way, they work seamless

[ghassanaldalati]

[Brett_Bleess]

Ghassan, have a look at the following Design Blog post, I think it should be helpful on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Regards,
Brett