Table To Table Programming

Guirg

Registered User.
Local time
Today, 01:44
Joined
Jun 2, 2009
Messages
96
Hey All,

I have a form that allows a user to input data directly into the original table. The original data was all in excel documents, and all the sheets have been imported. I have just recently been told that the data in a specific field B was originally based off a sheet (that i have imported.) The request is to use a number identifier to then update the columns automatically.

So hopefully to clarify: Field A in Table 1 refers to data in Field A in Table 2. The data from Field B (in Table 1) comes from Field B (in Table 2) based on the number from Table 1 Field A and its corresponding Field A in Table 2... Is there a way to do this via VBA. I'm way out of my depth with this!

Thanks
Tim
 
You description is not clear enough.
Post a simple example of what two tables might look like before and after the process.

I suspect it can be done with a query rather than having to resort to VBA.
 
Look up Foreign Keys in Access help. You do not need VBA for this.

You create foreign keys in the relationship editor.
 
Hey All,

Thanks for the help I've just done it by using queries as Galaxiom has suggested. The amount of VBA and Access ill make it look the same. I think i was trying to get too complicated yesterday. Cheers again
 

Users who are viewing this thread

Back
Top Bottom