Link batch number with barcode
Hi, i am creating an inventory database and i want to link batch numbers with barcode numbers. For example i would like a drop down menu with batch numbers and when i select one it would come up with a list of all the barcodes linked with that batch. is this possible?? I will really appreciate any help possible.