Using LINQ add CHILD VALUE always 1

Question

I have the Tables

PatientEligibilit and PatientsEligibilitiesDoctorsSpecialties and DoctorsSpecialties

PatientEligibilit has foreign key PatientsEligibilitiesDoctorsSpecialtyID from PatientsEligibilitiesDoctorsSpecialties table

and

PatientsEligibilitiesDoctorsSpecialty has foreign key DoctorsSpecialtyID from DoctorsSpecialties table

THEN USING VB.NET LINQ: i'm tring to add child item ( PatientsEligibilitiesDoctorsSpecialty) to it's parent (PatientEligibilit)

then I submit Changes

like :

PatientEligibilityObject.PatientsEligibilitiesDoctorsSpecialties.Add(New PatientsEligibilitiesDoctorsSpecialty With {.DoctorSpecialtyID = si.ID, .RegDate = Date.Now})                                                                            PatientEligibilityObject.PatientsEligibilitiesDoctorsSpecialties.Add(PEDS)
HMSData.SubmitChanges()

it's worked fine and save record in Database with correct date

BUT

DoctorSpecialtyID 

always saved with value 1

Answer 1

I solve it. the problem was in the relation between the tables.

The foreign key between PatientEligibilit and PatientsEligibilitiesDoctorsSpecialties was not correct..