help with referential integrity
From: JSF (JSF_at_discussions.microsoft.com)
Date: 12/14/04
- Next message: Brian Camire: "Re: Linked Oracle db in Access 2000"
- Previous message: slapana: "Re: Linked Oracle db in Access 2000"
- Next in thread: John Vinson: "Re: help with referential integrity"
- Reply: John Vinson: "Re: help with referential integrity"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Dec 2004 11:03:02 -0800
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?
- Next message: Brian Camire: "Re: Linked Oracle db in Access 2000"
- Previous message: slapana: "Re: Linked Oracle db in Access 2000"
- Next in thread: John Vinson: "Re: help with referential integrity"
- Reply: John Vinson: "Re: help with referential integrity"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|