Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to trace down an old table relationship

Status
Not open for further replies.

flugh

Technical User
Aug 23, 2002
655
US
Greetings!

It would seem 'way back when' that I had added an integer column to a table that was a foreign key to another table, then put in a one-to-many relationship. Long story short, after all this time, I have deleted the extra column and other table, but when I hit 'F9' to refresh a certain form, I get an inputbox prompting for this old value. I have searched my project's code, but there is no occurance of the old column's name, and I've search through the relationships window the best I can trying to find an old, stray relationship. No luck! Not that it's a fatal error, but it's kind of sloppy :)

So, is there some system catalog (Access 2000) that I can read through to try to find the reference to this old relationship? This needle-in-a-haystack method is wearing me out! :)

----
JBR
 
So I wasted most of the morning looking for the needle in the haystack. Then I hit the combobox listing all my controls on the form, saw one I didn't recognize. It was shrunk down and hidden, one of those "I don't really need it anymore, but there's too much code and work invested to just delete it" things. It's source query was the offender.

I will sleep well tonight now that it is fixed ;-)

----
JBR
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top