Linking reference cells in two tables

[Matt]

I have two tables, each with individual information about the same "Job".
The information is linked through the "JobNo" fields. What's the easiest way
to enter the JobNo in one table, and have it automatically insert it in the
other? Right now, I'm running an AppendQuery often, and I know that's not
the best way. The information from the two tables is brought together in
various forms we use in different departments for the "Jobs". Any help would
be greatly appreciated. Thanks in advance!

 

[Arvin Meyer [MVP]]

Generally, one should never work directly in tables unless one is both the
developer, and the application is trivial, since you cannot run code in an
Access table. If you use a form with a linked subform the JobNo field if it
is used as a link field will automatically fill in. If that's not the case,
you can run your append query in code in response to some event in the form.

 

[Matt]

Is there a better way to link this info together? Maybe I'm going about it
the wrong way. Specifically one table is the general job information, and
the second is the service information. For a simple example, if you have one
table for location information, and one table for invoicing information,
having them both related to one "job number" or whatever, what would be the
best route to go in linking them if starting from scratch.

Also, I wouldn't call myself a developer, but I am attempting to write a
decent database for my company, with the help of the people in here that are
actually qualified to do something of the sort. I'm not the average guy that
thinks he knows more than he does, but I'm not a developer by anyones
standards. I'm the drafting manager and I take care of all things electronic
here, including the setup of new machinery
--
-Matt

"The only thing worse than an employee that just quits and leaves, is an
employee that quits and doesn''t leave."

 

[Arvin Meyer [MVP]]

It is especially important for less experienced users to never work in
tables. Forms and subforms are the best way to go about linking the 2
tables. There are form and subform wizards that will do most of the work for
you.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com