In MS Access 2007, for example there are two databases, DataBase 1 and DataBase 2.
DataBase 1 has two tables Table 1 and Table 2. Table 1 and Table 2 are in a relation.If i link both the tables from DataBase 1 to DataBase 2, then the relationship is not getting displayed. I mean , in DataBase 2 under Relationships tab i can view the relation ships of the linked tables but in Datasheet view i am unable to see the relationship. In linked tables "+" sign is not viewed. Is this some problem with linking or some settings or a limitation in Access.If yes how can i fulfill my requirement of changing data here in both tables and reflecting it in other database and vice versa (not changing relationships)