Syed Haider wrote:
I've managed to get my schema and build the relationships by hand for
some tables.
^^^ what did you do by hand ? and why ? please explain.
Got the schema, it didn't find relationships automatically, not even
through key-guessing (and I have TABLENAME_ID on most tables).
Then I've selected the FK on satellite tables, pointed to central table
and got a simplified schema.
Built the dataset for all tables linked and got the _KEY_KEY_KEY_KEY stuff.
Now I've cleaned the XML to have only _KEY at the end of every key name
and now when I load the file it goes _KEY_KEY_KEY_KEY again.
cheers,
--renato