How to inherit attribute data from another table

Best Microsoft Access Programmer Portland OR

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?

submitted by /u/hquaker1
[link] [comments]

Microsoft Acess Developer Portland OR