Question abt self joined tables
-
Hello every one! Well I have a question here about the self joined table. Well I know how it works theoretically but I’m working on it for the first time in SQL Server 2000. I’m trying to build a data entry form for it and now I’m a bit confused that how do we manage the Foreign Key of that table. I don’t know if I’m putting this question in the rt manner. How do we make the forms over a self joined table. Plz answer that having the auto-increment PK in mind. I’m working in .net 2.0 C# Windows Forms. Thanks in advance… Rocky
-
Hello every one! Well I have a question here about the self joined table. Well I know how it works theoretically but I’m working on it for the first time in SQL Server 2000. I’m trying to build a data entry form for it and now I’m a bit confused that how do we manage the Foreign Key of that table. I don’t know if I’m putting this question in the rt manner. How do we make the forms over a self joined table. Plz answer that having the auto-increment PK in mind. I’m working in .net 2.0 C# Windows Forms. Thanks in advance… Rocky
I'm not an expert in this but since you've had no other replies, here is my opinion... Just create your form as if the underlying table didn't have a self join. It's purpose is to relate two fields in the same table and is really only to make data retrieval (queries, SP's etc) easier and more efficient. Steve