double tables in relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm running Access 2003 in a split database design.

In my forms database I have two table I need a link between.
schools
schoolsales

In the data database the relation ship shows only one of each of these
tables.

However in the forms relationship window it shows schoolsales twice. Once
with a link and the onther without.

I've deleted the second table from both the data and forms database but
everytime the second table comes back in the forms database.

I've deleted the table in the data relationship window. Then in the forms
relationship window but as soon as I open the forms relationship window the
second copy of the schoolsales is back.

Any suggestion how to perminentaly get rid of the duplicate table in the
forms relationship window.
 
When you open the relationship window select Show ALL tables. This will show
any rogue duplicated tables. Delete the link between the tables first, then
delete the table. Otherwise, if you don't the table will keep coming back
after deletion.
 
Back
Top