Relationships and Linked Tables

  • Thread starter Thread starter jfp
  • Start date Start date
J

jfp

I have a split database setup -- call the two parts "App" and "Data";
App has the forms etc. and Data has the tables. In App i link to the
tables in Data.

When i set up the first version of this:
1) i initially had everything in the App database, including relations
2) i made Data as a copy of App; deleted forms etc. from Data; deleted
tables etc. from App
3) in the App database i then set up links to the tables in Data
When i view relationships in App, i then see (but cannot modify) the
relationships among the tables in Data. So far so good.

Now, i have added more tables:
1) i made the new tables directly in the Data database (including
relations)
2) in App, i added links to these new tables.
Now, when i view relationships in App, i still see the previously
established ones, but i do not see those for the new tables.

Is there some special sequence that should be used for this ?
 
I'm not sure why Access doesn't refresh the relationships in the front-end database but don't worry. As long as the relationships are properly defined in the back-end database, RI will be enforced.

You can get the fe to show the relationships, by opening the relationship window and adding all the newly added tables. I think that once you add both tables of a relationship, the link automatically shows up.
 
jfp said:
I have a split database setup -- call the two parts "App" and "Data";
App has the forms etc. and Data has the tables. In App i link to the
tables in Data.

When i set up the first version of this:
1) i initially had everything in the App database, including relations
2) i made Data as a copy of App; deleted forms etc. from Data; deleted
tables etc. from App
3) in the App database i then set up links to the tables in Data
When i view relationships in App, i then see (but cannot modify) the
relationships among the tables in Data. So far so good.

Now, i have added more tables:
1) i made the new tables directly in the Data database (including
relations)
2) in App, i added links to these new tables.
Now, when i view relationships in App, i still see the previously
established ones, but i do not see those for the new tables.

Is there some special sequence that should be used for this ?
Click to expand...


Further to Pat's reply, whatever you see in the app mdb's
relationships is not being used by the db engine. The only
use you can make of the app relationships is for the default
Joins when you create a new query.

The real relationships can only be in the data mdb where the
tables really reside.

Because I sometimes forget where I am, I delete all the
relationships in the app side just to prevent mmyself from
inadvertantly trying to set a relation in the wrong mdb.
 
Back
Top