Database Split Without taking my relationships to the BE

[Guest]

I'm new to the database splitting concept. I split a database (I don't think
I used the wizard.) Everything is working like a champ except my
relationships are on the FE instead of the BE, which seems to be causing some
problems (allowing a zero value in the primary key of one of my tables.) I
think that I need to have my relationships in the BE. I have already
distributed the database to 3 users and have about 100 records in the
database. I have already modified both the front end and backend since the
split, so I can't just try to resplit the database. I thought that I had
tested to make sure that the relationships were working properly. Is there a
way to move the relationships into the backend? Any advice on how I can
correct the problem would be greatly appreciated.

Thanks,

 

[Guest]

How did you split the database? Manually or using the Database Splitter tool?
I just used the Database Splitter tool and it left the relationships in both
the FE and BE.

If you need to recreate the relationships in the BE, you may need to to it
manually OR it might be possible by running some SQL statements; however,
they would need to be run on the BE without a lot of fancy coding.

 

[Guest]

It was a couple of months ago, but I think manually. I recreated the
relationships manually in the BE and so far so good. Thank God I didn't have
too many relationships to do or it might not have been so easy.

Thanks for the suggestion Jerry.