Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / April 2008

Tip: Looking for answers? Try searching our database.

Linking reference cells in two tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Matt - 28 Apr 2008 16:37 GMT
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!
Signature

-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] - 28 Apr 2008 17:45 GMT
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.
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!
Matt - 28 Apr 2008 20:22 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.