<div>
What are the fields in steps table?
</div>


<div>
STEP_ID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;int &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unchecked<br />
STEP_Type &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;smallint &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unchecked<br />
STEP_RecordID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;int &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unchecked<br />
STEP_Description &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varchar(200) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unchecked
</div>


<div>
Is there any field which can be used to order steps?
</div>


<div>
No, as the step may be disconnected<br />

</div>


<div>
I tend to agree, what I will do is allow them to copy an existing step, that should get around the problem. <br />

</div>


<div>
<div class="content wysiwyg-content">
I have three tables Task, Steps and a join table, each Task can have unlimited steps. The problem I have is I need to store the order in which the steps appear, now if I store the order with the steps table I am unable to use existing steps within other tasks<br />
<br />
What is the best way of achieving this?<br />
<br />
I currently have a task object which has a collection of step objects. <br />
<br />
<br />

</div>
</div>


I have three tables Task, Steps and a join table, each Task can have unlimited steps. The problem I have is I need to store the order in which the steps appear, now if I store the order with the steps table I am unable to use existing steps within other tasks

What is the best way of achieving this?

I currently have a task object which has a collection of step objects. 




STEP_ID	int	Unchecked
STEP_Type	smallint	Unchecked
STEP_RecordID	int	Unchecked
STEP_Description	varchar(200)	Unchecked

Is there any field which can be used to order steps?

I tend to agree, what I will do is allow them to copy an existing step, that should get around the problem. 


Linked Tables + Adding an order column

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.