I have two tables, for example: Flights and Members. Flights store’s information such as flight_number, depart_time, arrive_time, etc. Member also has a flight number attribute.
I want it that when I select a certain flight number on a form when adding a new member, it automatically fills in the arrival and departure time as what the flight number’s arrival and departure times are. This is basically to make the data-inputter’s job simpler so they don’t need to keep copying the same info for the hundreds of people being added to the member table.
Is there a simple way of achieving this?