Re: Help : Problem with related tables
Date: 1998/03/15
Message-ID: <01bd5053$b1415b40$0100007f_at_localhost>#1/1
In MS Access (I'm assuming)
Go to Relationships view, Double click the line that indicates the link
between the two tables. A box appears: now select Enforce Referential
Intergrity (FIRST), then select Cascade Update Related Fields and Cascade
Delet related Records. That should do it.
Sofia Theodoridou <geoana_at_mail.otenet.gr> wrote in article
<34FBEDB6.E55E0788_at_mail.otenet.gr>...
> I have two tables (Oracle).Using ODBC I can see them from Access as
> linked tables. The JOIN established from Access.
>
> A part of the key of the second table is related with the primary key of
> the first table.
>
> When I update or delete a record of the 1st table (change the value of
> the primary key) I would like the related records of the second table to
> be updated or deleted too.
>
> How could I do these. I am trying to find something in Help
> Documentation but I have been lost.
>
> If you know the solution I would be greatfull to read it.
>
> Thank you in advance.
>
>
>
Received on Sun Mar 15 1998 - 00:00:00 CET