Re-establish Relationships

[indyhorses]

Since I was having a dbase problem with the labeling function, I exported each table, query, macro, everything into a new database. The only problem is that the relationships don't show up, even if you add the tables to the relationship window. Everything functions as it should, there is just no visible relationship? Problem? IS there a way to copy the relationships of the old dbase and bring them over?

 

[jflachman]

As far as I can tell, the relationships in the relationships window are only there as a default when creating queries. You can modify those relationships in the query window all you want. You can have no fixed relationships and define them manually every time you create a query. Once your query is designed, changes in the relationships window have no effect.

Therefore, since your queries all function, removing the relationships in the relationships window has no effect. You will notice when you go to create new queries that Access will either show no relationships or make a "best guess" that may or may not be correct. Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt