Using MS SQL for backend and Access as frontend

[wz]

I am using MS SQL for the backend of a Access database.

All my reports are working great.
All my queries are working great.

However one of my main forms...one in which the end user adds a new record - is giving me problems (It works perfect when everything is in Access)(and it works when exsisting data is edited). The error I receive is ODBC--call failed...The INSERT statement conflicted with the Foreign Key...

Any ideas...

p.s. I used MS SQL Server migration (worked well)

 

[PHV]

Seems like you insert a row with FK column referencing a non-existent value.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886