Project relationships

[jewel]

jewel (TechnicalUser) Jul 27, 2004
I have started a new project - ODBC connection
This is the first time I have used the project side - so was surprised to find no query window. Moving on I see I need to do relationships in the Diagram window.

I have a call table - primary key (field CallNumber)
and a worktime table - (has a field CallNumber)

that I am trying to link together - error reads
ADO error: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint

I'm not sure I understand what is wrong?

This is a lead up to doing reports using MS Visual Studio.net but I don't know enought sql code to do it directly. I also have MS SQL Query Analyser but felt if I could follow thru in Access it would be better for me to understand.

thanks

 

[cmmrfrds]

Apparently what you are doing in the Alter statement conflicts with a constraint you have set on a field(s) in the table. Do you have a constraint set up on a foreign key field in the table?