Hey hey,
New here and new to both access and VB. I not sure am i thinking this a bit unlogic or complicated. But I have a form whereby I have a field called Material and another field call ProcessMach.
1 type of material can go into different ProcessMach to start processing.
I want to do all transaction in 1 form so hence, my problem is that when a material is choose the combo box ProcessMach value also change according to the type of material chosen.
Example . Material A will oni go to machine X n Y
Material B will oni go to machine U n V
Is it possible or I am doing something imposible. Thank.