table relationships, split database (1 Viewer)

[alcifer_c]

Good day,
I recently split my database to be a front end/back end application. I noticed that my relationships didn't seem to be done correctly. If I load the back end, I can see all of the relationships as I set them up, however on the front end, they weren't there. So...I set them up again on the front end. The problem now is that it doesn't maintain referential integrity anymore and I cannot set it either because the option is greyed out.
Surely I've mucked something up. Should I remove the relationships that I set up on the front end? Will it then revert to the ones on the back end?

Many thanks, Al

 

[Mile-O]

I load the back end, I can see all of the relationships as I set them up, however on the front end, they weren't there.

That's because the BackEnd is where all the data storage happens. The FrontEnd is just an interface to these tables. The relationships will still hold throught the links.

Will it then revert to the ones on the back end?

Yes.