What happens to Relationships when you split?? 1

[mlsammie]

Hello,

I recently split a database and I am now not seeing any of my relationships. Did I miss something in the split or do I actually have to redo the relationships? If I need to redo the relationships, I am assuming I would want to do that in the backend? Correct??

Thanks for any insight!

 

[Crowley16]

depends on how you split your database really, if you riped out all your tables, and put them into a new database, then you'd loose your relationships, however if you kept your tables, and just exported all your forms/reports/queries/codes then your relationships would be intact.

I presume you used the first method, so yes, you have to rebuild your relationships. It doesn't really matter where you implement the relationships because they are infact bound to the tables, so you can have relationships between tables in your front end and your back end and a linked table from elsewhere...

--------------------
Procrastinate Now!

 

[willir]

Normally, you split data tables from forms / coding. The relationships are part of the schema on the "table" end. It is important to keep the tables together where appropriate for example, an Invoice "header" table and the Invoice "detail" table.

If you copy the tables from one database to another, only the table data and design are copied, and not the relationship.

If you approach the task from the "other end", or use the Database splitter wizard (hint), the tables and data will remain intact.

Moving on...
After splitting the back end / front end, when in the front end, you should see the tables with an arrow icon to the left of the table name indicating the table is linked. You can then view the table design, but only edit it from the backend. Likewise, you should still be able to see the relationships from the front end.

Lastly, you are correct in that if you need to recreate your relationships, and I perfer to do this on the backend.

Richard

 

[mlsammie]

Thank You both for the info. I originally had split the database with the database splitter and everything was great but I wanted to rename the database after the split and that didn't go so well. I then had to create a new DB and imported the tables from the old DB. I think that is when I lost my relationships. At least now I know when it happened. Thanks so much, you guys are great!