Lookup dependant on predefined option

I am a new developer, and I am looking to be pointed in the right direction. I am trying to use a lookup that changes, dependant on an option. Could anyone suggest an object that I could look at for some ideas. Thanks Dean Axon

Check table 37(Sales Line) and field 6(No.)