help with referential integrity

I have a database that is the design master.
I had copied a table (i assume the parent)and pasted it(table 2). It was
redesigned to fit my needs. I then created another table(table 3) from the
make-a-table query. What I want to be able to do is to make corrections in
one table(table 3) that are also reflected in the other (table 2). I am able
to make a one to one relationship with all the integrity options but when I
try to make corrections in either table, I get an error saying that the
object specified cannot be replicated because it is missing a necessary
resource. How do I fix it?

On Tue, 14 Dec 2004 11:03:02 -0800, JSF
wrote:

I have a database that is the design master.
I had copied a table (i assume the parent)and pasted it(table 2). It was
redesigned to fit my needs. I then created another table(table 3) from the
make-a-table query. What I want to be able to do is to make corrections in
one table(table 3) that are also reflected in the other (table 2). I am able
to make a one to one relationship with all the integrity options but when I
try to make corrections in either table, I get an error saying that the
object specified cannot be replicated because it is missing a necessary
resource. How do I fix it?

You're on the WRONG TRACK.

Storing data redundantly in two tables, and expecting relationships to
automagically copy data from one table to another (other than copying
the Primary Key to the Foreign Key) is *never* a good idea. One to one
relationships are *not* designed to do this.

Replicated tables have several extra hidden fields to handle
ReplicaID's; a MakeTable query will not add these unless you
explicitly include them *and* have a very solid understanding of
Replication. There are perhaps three people in the world who have such
an understanding and I'm not one of them!


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

Ah SHucks. I was using the duplicate table as a base to create a report from
various non database sources like excel spread sheet. And as I found errors
I was hoping to eliminate the need to correct each table separately.

JSF

"John Vinson" wrote:

On Tue, 14 Dec 2004 11:03:02 -0800, JSF
wrote:

I have a database that is the design master.
I had copied a table (i assume the parent)and pasted it(table 2). It was
redesigned to fit my needs. I then created another table(table 3) from the
make-a-table query. What I want to be able to do is to make corrections in
one table(table 3) that are also reflected in the other (table 2). I am able
to make a one to one relationship with all the integrity options but when I
try to make corrections in either table, I get an error saying that the
object specified cannot be replicated because it is missing a necessary
resource. How do I fix it?

You're on the WRONG TRACK.

Storing data redundantly in two tables, and expecting relationships to
automagically copy data from one table to another (other than copying
the Primary Key to the Foreign Key) is *never* a good idea. One to one
relationships are *not* designed to do this.

Replicated tables have several extra hidden fields to handle
ReplicaID's; a MakeTable query will not add these unless you
explicitly include them *and* have a very solid understanding of
Replication. There are perhaps three people in the world who have such
an understanding and I'm not one of them!


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps