relationships layout

[CraigDolphin]

I had a couple of forms go corrupt in one of my databases this morning, which has around 50 or so tables in it. I repaired the database by creating a new db then importing all the db objects from the original and the 2 corrupted forms from yesterday's backup.

However, the relationships table is now a disorganized mess. Is there some way to import the layout of the relationships table from the original db or am I stuck with manually re-arranging?

 

[boblarson]

When you go into File > Get External Data > Import, before you import everything click the OPTIONS button and make sure Relationships is checked.

 

[CraigDolphin]

Thanks for the reply.

I had checked the box and the relationships were imported, just not with their layout intact. What was a carefully laid-out arrangement is now a tight grid of tables with a spiderweb of criss-crossing join lines

 

[boblarson]

Oh, that - Sorry but Access has a mind of it's own on that one (another fine product brought to you by Microsoft )

 

[CraigDolphin]

That's what I was afraid of

Thanks anyways!