Primary key

[Jimmy]

Hello

I have a problem with a primary key. A table called relaties has a column relatienumber with date type: number, which is also the primary key. When a button is pressed, a function searches info from the table relaties.
The problem is the following: I figured out that when i remove the primary key constraint from the column relatienumber and save the table. the function doesn't work anymore, also when i remake the primary key for this column. How is this possible, because i changed nothing futher.

This is important because i want to change to access db to mssql db and in mssql the function also doesn't work.

It has something to do with this primary key constraint, i think

Who has the info???

 

[Jimmy]

Hello Pat,

I changed my post. I deleted the text with the foreign key stuff. The central problem is with the primary key. When i change the column from primary to normal and i save the table, the function doesn't work anymore. Also when i change back the column to primary key the function still doesn't work anymore. Only when i get a copy of the old table the function works again.

How is this possible??. This is probably also the reason why this function doesn't work in mssql.

Jimmy