Thanks very much !!
Both of the ways work good. I was using 'from' clause in my update query hence syntax error.
Removing that and rearranging the query yielded results. :)
Regards,
Trueman
TrueMan2010
Last Activity: Feb 9 '10, 06:32 PM
Joined: Jan 18 '10
Location:
-
Nic,
Can you take stab on this one please?
Error: missing operator in expression 'tblA.Field5=.. ............=tb lA.PID'
Just trying to update certain records in one table based upon corresponding records from another table.
In some another forum I got the idea of using DLOOKUP and I'm looking into that as well.
Kind Regards,
Trueman :)...Leave a comment:
-
Hi Nic,
I used this query to insert records into child table
Thanks !!
Trueman...Leave a comment:
-
Thanks very much !! Nic,
I'll try your solution and post back with the results.
Kind Regards,
TruemanLeave a comment:
-
Not really !
Let me explain what I understood.
Table1 (parent)
ID1 A B C
Table2(Child)
D E F ID1 ID2
So, I have to add an auto increment column say(ID3) in both the tables?
Then, insert new records in Table1.
After this operation ID1 gets populated by new values. Then what would be the next step?
Use ID3 values to get values in...Leave a comment:
-
Inserting new data within related tables inside Access
Hi All,
I need to insert new records in existing Tables of Access. The two tables are related by Primary and Foreign key relation. The new data to be imported is in Excel sheet which I have imported into new table.
Now,
Some columns needs to be inserted into Parent table and some would be inserted to child table.
The parent table has an automatically incremented ID column which is foreign key for the child...
No activity results to display
Leave a comment: