I've lost my relationships!

[Guest]

Well, not really...but my front end doesn't show them anymore.

I had to add some security, which for me a databse password was enough. I
ended up relinking all of the tables from the BE after I added the pwd to the
BE. All the new links were named the same save for the "1" appended to the
name. I deleted all the old links, and changed the names of the new linked
tables to match the old names, thus allowing my application to work.

So I'm guessing that what I did screwed things up. Now, viewing the
relationships affects only me, and the rules are still in force, but there is
a bit of convenience having to manually create joins in queries...

Any way for me to get these relationships "back" other than manually
creating them in the FE diagram? TIA

 

[Douglas J. Steele]

There's no need (nor point) to have relationships in the FE. As long as
they're in the BE, you're okay.