Hi. In my Railroad database. I have a field for the station name, code and distance. The user can populate these fields manually however they make mistakes. I created a value list for "station". my goal is once a station is selected the "code and distance" fields are populated with the right information. Example. I have 3 stations and their codes and distance;
Station code distance
Jaguar JGR 200
Panda PND 100
Oxford OXD 230
now once the user selects Panda as station, the Code field is populated with PND and the Distance with 100.