FE/BE and Relations

[JK]

I have manually splitted a number of databases. There is no problem there,
however, I have just noticed that the relations are set up in both Front
*and* Back Ends (identically, for now). I suspect that this is incorrect.

Can someone guide me?
TIA

Regards/JK

 

[Allen Browne]

It's probably okay.

You cannot actually create the relations with referential integrity (RI)
between tables in different databases. If you open the back end, and can
confirm that the relations exist with RI, they are set correctly. The front
end is then just reporting the relations that exist in the back end, not
actually duplicating or managing them.

 

[JK]

Thanks mate, appreciate.
JK

It's probably okay.

You cannot actually create the relations with referential integrity (RI)
between tables in different databases. If you open the back end, and can
confirm that the relations exist with RI, they are set correctly. The
front end is then just reporting the relations that exist in the back end,
not actually duplicating or managing them.

 

[John Vinson]

I have manually splitted a number of databases. There is no problem there,
however, I have just noticed that the relations are set up in both Front
*and* Back Ends (identically, for now). I suspect that this is incorrect.

Can someone guide me?

The actual relationships exist in the backend, and if they are to be
changed, must be changed in the backend.

By default they're "echoed" in the frontend.

Any new relationships defined in the frontend are for documentation
only - they cannot be enforced (since the backend might be opened
separately, and the rules defined in the frontend will be powerless to
prevent the separate process from breaking its rules).

John W. Vinson[MVP]

 

[JK]

Thanks for the explanation John,

This is what I had expected except to see the relations in the front end.
It now all clear.

Regards/JK