Combo Box filtering (1 Viewer)

wajidpharmacist007

New member
Local time
Tomorrow, 01:40
Joined
Nov 23, 2018
Messages
18
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

New member
Local time
Tomorrow, 01:40
Joined
Nov 23, 2018
Messages
18
Thanks alot i have removed batch no from issuance table and taking product name from purchasing

Many many bundle of thanks
 

Users who are viewing this thread

Top Bottom