Cascade Delete / Linked Tables

24 Feb 2005 1:03 AM

DS

I have a split database..Tables in one, the rest in another.
On the tables one I have a cascade delete set-up between 2 tables, this
worked fine until I split the database...Now the cascade delete shows in
the tables one but not the front end one. How do I remedy this situation?
Thanks
DS

24 Feb 2005 2:54 AM

Rick Brandt

DS wrote:

> I have a split database..Tables in one, the rest in another.
> On the tables one I have a cascade delete set-up between 2 tables,
> this worked fine until I split the database...Now the cascade delete
> shows in the tables one but not the front end one. How do I remedy
> this situation? Thanks
> DS

It only needs to be in the back end. Relationship lines that you draw in the
front end don't really do much of anything other than document the
relationships.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

24 Feb 2005 5:19 PM

DS

Rick Brandt wrote:

> DS wrote:
>
>>I have a split database..Tables in one, the rest in another.
>>On the tables one I have a cascade delete set-up between 2 tables,
>>this worked fine until I split the database...Now the cascade delete
>>shows in the tables one but not the front end one. How do I remedy
>>this situation? Thanks
>>DS
>
>
> It only needs to be in the back end. Relationship lines that you draw in the
> front end don't really do much of anything other than document the
> relationships.
>

Thank You...I also found the problem. I had to move the requery action
to a different part in the code. Everything works fine now.
Thank You
DS