Database splitter

[RobS101]

I made a copy of this db and split it using the database splitter. I opened the Relationships window nad noticed that none my tables were hooked anymore. If I reset all the relationships the way it was before is it going to be stable?

 

[Jack Cowley]

The relationships are in the back end. They should not have changed after splitting and you do not need to make any changes to them in the front end.

hth,
Jack

 

[Pat Hartman]

Actually, that is what I thought also but recently, I split a db using the splitter in A2K and made the mistake of not checking. It did NOT transfer the relationships to the be. This caused me some serious embarassment since it allowed the fe to create orphan records because cascade delete was not turned on.

 

[Jack Cowley]

Pat -

Thank you for that valuable piece of information!

Jack