Updating a text box from a value in another text box (underlying q

[Guest]

Hopefully someone out there can help,

There is probably a simple way of doing this but I am at a loss (I wouldn't
consider myself an expert in access)

Anyway, here is what I'm trying to do.

I am currently using a form to update a table, One of the fields is for a
job number. An additional text box on the same form is for the job name.
What I am trying to do is have the job name automatically fill out by using
data from a different table that already contains the job name information.
I have the two tables already relationshipped according to the job number,
but how do I tell Access to update the 2nd text box with the name information
based on what the user has entered as a job number in the first box?
I suspect that I need to run a query in the background but I'm not sure how
to do this.
(Would I use the expression builder?)

Hopefully what I wrote makes sense. If you need more info. please let me
know. I'm getting tired of knocking my head against my cubicle.

Thanks
Jim

 

[Guest]

If you already have the job name in another table, you shouldn't put it in
this table. Data Redundancy is a violation of database normalization. All
you should need is the primary key of the record in the other table where the
job name is stored to be able to display it for the user.

If your form's record source is a query, add that table to it and bind the
control where you want to display it to the job name field. If you are using
the table as the record source, switch to a query and do the same thing.