Referential integrity-Don't know what i am doing

[pierrotsc]

If there are any example on how to setup a simple master/details database that when you insert a new record in the master, it will create one automatically in the details, please let me know.

Right now I am getting this error:
NexusDB: nxTable_trials: Referential Integrity Violation. Trials(Project_No) -> Projects(Project_No): Master record missing. [$2605/9733].

My master database is called projects:
Project_No (autoinc)
Description

Details database is called trials:
Trial_No
Project_No
Description

In the referential integrity of trials, I tell that Project_No from trial to be associated with Project_No from project.

I do the same thing under the component nxTable_trials. I tell it what the mastersource is and assign the index to match.

Under the newrecord property of the master table, I have this command:
nxTable_trials. insert; // to create a new detail record when a master one is created.

Under the new record property of the detail table, I have:
EmbeddedDM.nxTable_trials.FieldValues['Project_No'] :=
EmbeddedDM.nxTable_Projects.FieldByName('Project_N o')
.AsInteger;

Do I have to write that? Or is that supposed to be assign automatically?

Well, anyway, this setup triggers the error I wrote above.
If some kind soul can tell me on how to fix that, that would lower my frustration level.

Thanks.
P