Relationships looking for an old parameter

shacket

Registered User.
Local time
Today, 18:22
Joined
Dec 19, 2000
Messages
218
I have a one-to-many relationship between two tables. When I first set up the database, I linked them on a certain keyID. I have since linked them on another. In fact, the first is not even in the tables anymore. However, when I am in the "one" table and click on the plus sign, it prompts me for that old keyID as a parameter. I have checked the relationship designs as much as I know how but can't find what would cause the db to be looking for this old field. Any ideas of how to troubleshoot this?

Thanks.
 
I figured it out. In the design mode of the table, under properties is a link master and child fields line. The wrong field was listed there.
 

Users who are viewing this thread

Back
Top Bottom