Access Database Help

Access Database Help

Post by amlsZX » Tue, 03 May 2005 03:34:03


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.
 
 
 

Access Database Help

Post by Rick Brand » Tue, 03 May 2005 04:31:37


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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com