I want to Show the product list based on the drop Down

I want to Show the product list based on the drop Down

in quotation app , amc form  form  i have Department drop down field  and in subform i have loop up field item description taken from the anothe app  PRO

I want to show the product   list look up based on the deparment selected

 example 

if they selected deparment   Machine then only show the  machine related product in the lookup.

 is it possible to get data from different app using fetch Record