I am trying to figure out a way to have information selected from one combo box determine what is show for selection in a second combo box. i.e.
I have a combo box that has Plant Names (LA, Winterhaven, Orrville, Sylacauga)
When say Sylacauga is selected I want to be able to show what line numbers Sylacauga has for selection in a second combo box.
Is there anyway to do this? Do I have to have a relationship that I don't currently have or is it coded?
Any help would be appreciated.