
Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
>I have two tables, each with individual information about the same "Job".
> The information is linked through the "JobNo" fields. What's the easiest
[quoted text clipped - 6 lines]
> would
> be greatly appreciated. Thanks in advance!
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

Signature
-Matt
"The only thing worse than an employee that just quits and leaves, is an
employee that quits and doesn''t leave."
> 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
[quoted text clipped - 11 lines]
> > would
> > be greatly appreciated. Thanks in advance!
Arvin Meyer [MVP] - 29 Apr 2008 21:15 GMT
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.

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
> Is there a better way to link this info together? Maybe I'm going about
> it
[quoted text clipped - 40 lines]
>> > would
>> > be greatly appreciated. Thanks in advance!