Duplicating Data

pjStyle

Registered User.
Local time
Today, 11:37
Joined
Nov 24, 2003
Messages
13
Newbie question :)

I have a very simple question. I'm working on a school project now, but i don't have too much experience in access. The thing is, i have a Table A and a Table B.
Now when i insert a record into table a, at the same time a record must be inserted into Table B with the same primary key.
I connected the two tables and enforced referential integrety and checked the update Cascade Update Related Fields box. I thought this would solve my problem, but it didn't.
Anybody know what i'm doing wrong??
 
Why would you want the same data in 2 tables?

Col
 
It's not the same data :)
One table lists the name, address, etc. and table B lists all qualifications of a certain candidate from Tabla A.

I want to divide the data over two tables because the total number of fields of the two tables is like 50+
 
Your data doesn't sound normalised, post an example of your table structure
 

Users who are viewing this thread

Back
Top Bottom