I am doing something very similar to what Martin is doing...
I have a legacy Access DB that I am loading via an ODBC connection
into Obj-C arrays. I am then cycling thru each table picking out only
specific fields of the table to put under CoreData's control in a
SQLLite store. I am cycling thru doing fetches based on integer ID's
to recreate the relationships that I need.
I already have my indexes indexed and have some pretty simple fetch
requests defined that make the code easy to write and implement.
When I get to the first table that I need to recreate a one-to many
relationship I find that if after specifying the first connection if I
don't force a save of the managedObjectContext then the next fetch
that is for the index comes up with 0 results. Here is part of my
code...