Access Database Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field that Idenitifes Land Tracts by number. The next field is the
tract name. I want to Have the tract name auto entered when I type in the
tract number in the seperate field. How do I do this please.
 
jiles said:
I have a field that Idenitifes Land Tracts by number. The next field
is the tract name. I want to Have the tract name auto entered when I
type in the tract number in the seperate field. How do I do this
please.
Click to expand...

When you enter it where? If you are creating records in another table besides
LandTracts then you should not be storing anything from LandTracts except the
number. All other data that you want to *display* can be pulled from the
LandTracts tables with lookup mechanisms.

Other than linking fields data should be stored once and only once.
 
Back
Top