Combo Box filtering (1 Viewer)

[wajidpharmacist007]

Hi I am new in access and i am confused how to handle data.
I have three tables
One table Product Name having fields ID, Product Name, Generic
Second Table Purchasing having fields ID, Product Name (linked with table Product Name with one to many relation), Batch No, Rate, Qty and Date
Third Table Issuance having fields ID, Product Name(linked with table Product Name with one to many relation), Batch No (linked with table Purchasing with one to many relation) and Qty.
On form i have two combo boxes one for Product Name and second for batch no. I want when i select product name from drop down menu of combo box it should show only batches of that product name from purchasing table.
Is this possible if yes then how to configure all these. Thanks

 

[wajidpharmacist007]

Thanks alot i have removed batch no from issuance table and taking product name from purchasing

Many many bundle of thanks