Dan Waters
dwaters at usinternet.com
Mon Nov 27 09:04:37 CST 2006
Thanks Gustav - that's good to know. With what I was looking at, it was truly a duplicate relationship and was not needed. Dan Waters -----Original Message----- Subject: Re: [AccessD] Table Relationships Hi Maybe. It was not a "ghost" table. If you had more than one relation to a table, the second and third are by default named _1, _2 and so on. Now that second relation is lost. /gustav >>> dwaters at usinternet.com 27-11-2006 03:06 >>> That was it! Thanks Greg - I was getting a little spooked! Dan Waters -----Original Message----- Subject: Re: [AccessD] Table Relationships Dan: Does the 'ghost' table have a relationship (or an apparent one)? If so, you may have to delete it first, then delete the ghost table, and then save the relationships. That's always gotten rid of the ones I occasionally get. Greg