Looping through linked records
<p>I am not sure if this is possible, but maybe someone could advise.</p>

<p>We have records set up in our system as follows:</p>

<pre><code>Product_ID | Product_Name | Product_Price | Original_Product_ID 
</code></pre>

<p>when a product is modified a new record is created with a reference to the previous encarnation in the <code>Original_Product_ID</code> field.</p>

<p>What I want to do is pass in a <code>Product_ID</code> (Current) and return the product which this came from, in some cases this will return the same as is passed in, in other cases I will need to loop through a number of records.</p>

<p>Please can someone advise on this...</p>
