Hi Why is this throwing a foreign key violation. I am using self servicing inside VS2K3 with SQL2K...

    Dim d As New DepartmentEntity(Guid.NewGuid)
    d.Name = "Information Technology"
    d.Save()

    Dim e As New EmployeeEntity(Guid.NewGuid)
    e.LastName = "Hill"
    e.FirstName = "Steven"
    e.Department = d
    e.Save()

Is d a new entity or did it already exist? Can you post the sql trace for the code that you have listed. Look under the troubleshooting section of the manual for how to enable tracing.

You've probably hidden the relation Department -> Employee. Unhide it and regenerate the code.

Yes, indeed I hid it.

I guess I am confused. I hid the relation on Department because Department doesn't have an employee... Employee Has a Department. So I left the relationship on Employee.

I guess you are saying I need both?

Already answered in the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5845