StrataFrame Forum

Can not set self relationship

http://forum.strataframe.net/Topic1447.aspx

By fookyean - 6/7/2006

I try create the a table that has relationship with table itself, but DDT do not allows.Unsure

For example, Employee Table that has emp_pk as PK and emp_superiorpk as a foreign key that refer to the superior pk refer to the Employee Table as well as below:

employee (1)---> (0,m) employee

How I can create this in DDT ?

By StrataFrame Team - 6/8/2006

Ah, I didn't even realize that that was a business rule in the DDT.  It's certainly allowed in SQL Server, so I removed the rule, and you will be able to do it in the next version that will be released here in a few hours.
By StrataFrame Team - 6/8/2006

The update has been posted in the MyAccount area.