By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,917 Members | 1,305 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,917 IT Pros & Developers. It's quick & easy.

Help - logbook.

P: n/a
I'm building a simple flying logbook.

I have a table with the registrations of all the aircraft I have flown and
what type of aircraft each is. I am now building a form to input all my
flying data into another table. How is it possible for me to input aircraft
registration in one field and have the aircraft type automatically placed in
another field?

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Kevin Barnard" wrote
I'm building a simple flying logbook.

I have a table with the registrations of
all the aircraft I have flown and what
type of aircraft each is. I am now building
a form to input all my flying data into
another table. How is it possible for me to
input aircraft registration in one field and
have the aircraft type automatically placed
in another field?


As you already have the table of aircraft with registrations and type,
consider using a ComboBox based on a query that retrieves registration
and type into two columns. That way, you _choose_ the appropriate
registration, rather than having to enter a long and unintuitive
identification. Further, when you do, you can access the type by using
the Column property of the Combo Box. If aircraft type is in the
second column of the Combo, in the AfterUpdate of the Combo, this
code:

Me!txtType = Me!cboYourComboName.Column(1)

will set type into the TextBox on the Form that is named "txtType".

That said, the Table design you describe is "unnormalized" by
Relational Database design principles, and you may save yourself some
later effort if you'll only store the Registration and obtain the
Ttype by joining the tables on the Registration Field in a Query when
you need to use or display the information.

Larry Linson
Microsoft Access MVP
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.