AnsweredAssumed Answered

Railrod Databse

Question asked by dmayembe on Sep 26, 2013
Latest reply on Oct 1, 2013 by dmayembe


Railrod Databse


     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.

     Any Idea?

     Thank you