So i have a combo box on my form listing all my serial numbers for a vehicle database.
My table includes information such as
Serial #
Warranty
Make
Model
etc...
Is it possible to make it so that when i select the Serial # in the combo box that it will pull up the warranty information for that vehicle only in another combo box or something else? And if so where would i start or what options should i be looking at?
Also if there is a more efficient way of doing this , such as like just typing in the serial number in a box and it will pull up all the information how could i do that?
Rather new to do this so I am not looking for a hand out rather just guidance on the direction i should be heading.
Thanks.