Re: foreign key constraint fails

[Jon Erik Ween]

Thanks Peter, appreciate the tip

But I actually fixed the data formatting issue on the web interface since my original post and there is still nothing doin'.

Funny thing is also that the INSERT actually worked with the wrong date format as long as the lookup.ID was <115! (the date field value was 000-00-00, but the insert was allowed).

Anyway. After fixing the date format so the insert date field is correct, I can still insert with Lookup.ID <115, but get the field constraint error with anything >114. There seems to be something magical about the ID value.

Ideas?

Cheers

Jon