Update Multiple Fields

  • Thread starter Thread starter Walter Steadman
  • Start date Start date
W

Walter Steadman

Greetings all,
I have a table called tblAircraft and it contains the following fields
(this is more of a Lookup table)
TailNumber
AircraftType

I have another table called tblHoursFlown
the fields in this table are:

PilotID
flyDate
TailNumber
AircraftType
HoursFlown

I have a form built for tblHoursFlown and what I am trying to do is, when I
select the Tailnumber from a Drop down box that uses the tblAircraft
TailNumber as its source, I would like it to populate the Aircraft Type with
the corresponding Aircraft Type located in the tblAircraft table.

Example

tblAircraft

TailNumber AircraftType
1234 UH-60
2345 UH-60
3456 AH-64

When I am filling in the form (based off of tblHoursFlown), and I select
1234 as the TailNumber, I would like the Aircraft Type to put UH-60 in
Aircraft Type field on the form.

Not sure how to reference or where to reference it at.

Any assistance would be appreciated.
 
Walter said:
Greetings all,
I have a table called tblAircraft and it contains the following
fields (this is more of a Lookup table)
TailNumber
AircraftType

I have another table called tblHoursFlown
the fields in this table are:

PilotID
flyDate
TailNumber
AircraftType
HoursFlown

I have a form built for tblHoursFlown and what I am trying to do is,
when I select the Tailnumber from a Drop down box that uses the
tblAircraft TailNumber as its source, I would like it to populate the
Aircraft Type with the corresponding Aircraft Type located in the
tblAircraft table.
Example

tblAircraft

TailNumber AircraftType
1234 UH-60
2345 UH-60
3456 AH-64

When I am filling in the form (based off of tblHoursFlown), and I
select 1234 as the TailNumber, I would like the Aircraft Type to put
UH-60 in Aircraft Type field on the form.

Not sure how to reference or where to reference it at.

Any assistance would be appreciated.
Click to expand...

It's best to not do this. Eliminate AircraftType from tblHoursFlown and
build a relation between that table and tblAircraft.
Use a query based on that relationship to display the information.

While it's not a big deal here, if you used this approach to fill the
pirates (funny only if you like Gilbert and Sullivan) last name and the
last name changed you would have a lot of work to do.

The Northwind database has examples of this.
 
Mike,
Thanks for the assist. I totally got what you were saying and it works
great. Appreciate it

Wally
 
Back
Top