Table joining/relationships

[Jeremy Flint]

I'm creating a database for work and am pretty new to
Access. I'm also not sure how to phrase my question, so
I'll give a little background on what I've done so far.
What I have so far are 3 tables.
One table to hold the data input by the users (myself and
one other person) used to track office proccesses.
The second table is one that contains geographic location
information. the first column is the geo loc code (4
characters), the second column is City, third column is a
2 character state or country code, and the fourth is the
state or country cleartext.
The third table has 2 columns, one for a remark code, and
the second is the cleartext of what that particular code
means.

What I want to do is create a way for the user to input
the raw data (geo loc code and remark codes) into a form
and have the first table updated to reflect the cleartext
of what the codes are. IE: If the geo loc code was ABCD,
and in the geo table, ABCD meant Montgomery, AL, that's
what I'd want displayed/kept in the primary table. I don't
know if this is possible, but it would make things easier
for us, as we'd be using this to merge data to a Word
document (among other things) for notifications/invoicing.

If anyone can help me on this, it would be very much
appreciated. I've pretty much had to learn Access on my
own, and have looked in the newsgrouops, but honestly
don't know what I'm looking for.

Thanks,
Jeremy

 

[Nikos Yannacopoulos]

Jeremy,

It is certainly possible to include automation in a form to update a table
based on another, but... it is also completely unnecessary and, frankly,
quite bad practice! It defies the whole idea of relational databases. If
it's in another table, don't multi-store it in your main table, just keep it
once in its original table (geographic location information, for example),
and when required (to display on a form or report) join the two tables on
the common key in a query, and pull it from there.

HTH,
Nikos