Linked Tables

[isorders]

I have a list of Projects that I pull from a SQL database.
Table SQLPR.
I don't want to mess with tblSQLPR or the database, but I need to add some more fields like line length, line size, project type etc. so I created an .mdb file.
I want the project list to always be current but I can't figure out how to merge the tblSQLPR information with the Access.
I want to end up with a mdb table (tblPR) like...
prProject (pulled from SQLPR)
prLine_Length
prLine_Size
prProject_Type
Once everything is updated, if a new tblSQLPR project is added it will show up in tblPR with no Line Length or Line Size, etc.
I want to set this up in datasheet view so that updating the Length and Line Size will be easy.

 

[cghoga]

set up an ODBC link to your SQL table and create your new table in Access. Make sure to have a foreign key in the new table so you can properly link back to the SQL table.

hope this helps you.

 

[isorders]

I understand the concept, but I don't know what a foreign key is in Access and don't see it in the help.
The tblSQLPR is linked through an ODBC connection.