Hello.



Firstly, if I have posted this in the wrong part of the forum, I do apologise.

I am trying to create a database into which I can input railway journeys that I go on. I would like to include the date, beginning, end, train travelled on, distance travelled (in miles and chains*) and any notes for each journey I make (although I would also like to be able to add further fields in the future if necessary). My database currently has 3 tables - JourneyList, into which I will input journeys, UnitList, which will contain a list of all trains in the UK, and StationList, a list of all UK stations; the fields for each table are: JourneyID, JourneyStart, JourneyEnd, JourneyUnit, JourneyDistance, JourneyNotes; UnitNumber, UnitMileage, UnitClass, (I will add further fields here as the database develops); StationCode, StationName.
*Would this be best as two fields, one for miles and another for chains?

How should I link all these fields together?

If possible, I would like the following outcomes:
  • when I enter a station name into the JourneyStart/End fields, I can type either the station code or full name, and a drop-down list of stations appears (like on an online journey planner).
  • when I input a distance for the journey, this distance is automatically added to the value in the UnitMileage field of the train in which I have travelled. If I go on multiple journeys on the same train, the total mileage is displayed. When I get around to making forms for each train, I would like a button that, when pressed, displays all the journeys that I have made on that particular train.

I am open to all suggestions.

Many thanks in advance for your help. If you need anything explaining further, please ask.