Okay, here goes:

I have a database with the following tables and pertinent columns that I am connecting to using an Access data project file:

Employee
EmployeeID - PK
...

CycleOwner
CycleID - PK
EmployeeID - FK
ProcessID - FK
...

Process
ProcessID - PK
...

SubProcess
SubProcessID - PK
ProcessID - FK
...

ControlActivity
ControlActID - PK
SubProcessID - FK
(2 look ups to Employee ID for other reasons)

When I try to create a record in the ControlActivity table, I get an error that ProcessID is an invalid column name. When I create the record in ControlActivity, I select a SubProcessID, which is already related to a ProcessID back in the SubProcess table, but there is no look up to ProcessID in the ControlActivity table.

Any ideas?

Thanks,




mmcdonal

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

Just to clarify, you are only dealing with the controlActivity table, e.g. the problem is occuring when you insert data into the controlActivity table?

"The one language all programmers understand is profanity."

Just the control activity table.

I recreated the table and after dropping the relationships on the old one and dropping the table, I was able to connect the new one and get everything to work. I would like to avoid that next time if you have any suggestions.

Thanks.

mmcdonal