Lost relationships between tables

[riggsd]

I was trying to use the Query Wizard and it said that my tables weren't related so I looked at the relationships and there are no longer any lines connecting my tables. I'm checking back through backups and they are missing there too until I get to backups I made in February 2017. However, I've been able to create new queries using Query Design all this time with no issues and all my old queries, which rely on relationships, still work.

Does anyone know how this may have happened and is there a way to get them back without having to manually recreate each relationship?

ETA: I did split the database but that was last week so the relationships were lost way before I split the database.

Thanks in advance.

 

[Joe4]

Hmmm, not sure. If you do not have it in any backup, I am afraid that you may be out of luck.
Did you check BOTH the front and the back-ends of the database for the relationships?

Personally, I do not set the relationships between tables in the database. I write each of my queries explicitly, where I manually set the joins in each one.
Because I do it this way, I have never experienced the issue that you are describing.

I am not sure what the "best practice" is, but I know of many other programmers who do it the same way I do.

 

[riggsd]

I do have the relationships in old backups but from early 2017. After that, they just disappeared. As long as I use the Query Design tool which manually creates the joins, I'm fine. I just can't use the

 

[Joe4]

Did you check both ends of the split database for them?

 

[james_lankford]

... until I get to backups I made in February 2017...

so their relationship broke right around Valentine's Day ?
that's sad

 

[riggsd]

Yes, very ... so far, I'm not seeing issues with queries, I just can't use the query wizard, which I rarely do anyway.

 

[Joe4]

I just can't use the query wizard, which I rarely do anyway.

I wouldn't think that would affect that. I never set relationships in my databases, and am able to use the Query Wizards without any issues. Usually, that ask you to map the join field in them.
If there is more one join field, you can just join on one field, and then edit it once complete to add the other joins.