Database

Thank you jschell.
    But I must apologise as after returning to work today and looking at the programme in which I am trying to copy some functionality from, I have realised I haven’t explained what I am after properly, and fear I have caused some confusion. But as for what you have told me in the above it validates most of the code I have written, thank you for that.

    With that I’ll try again to explain myself, I caused confusion by saying there was a search involved "Apologies". In a nut shell what I am after is basically "Selecting and displaying a page based on a records location". Now I know that until a query is run against the table there is no theoretical position of a record. But what the programme does is open the pageForm on page one of the data in that table. Although there is a ID column on the table (as I have poked around in the programme files) the page is organised by the first column which is stock-Code. Hence you can page through all the results from a stock code beginning with "A" right through to "Z" which I think is around probably 1000 pages at the minute, not that we go through them all. Then a user opens a new form to edit or add a new record, when the form is closed and the data returned to the database the pageform will display the page relevant to the stock code added, and you can page backwards and forwards from this page. The same applies to the search, which is conducted in a separate searchForm, which displays the possible results for that criteria, which the user selects one, and returns to the pageForm which now displays the page with that record on.

Do you jschell or any one have any idea of how this is accomplished?

1,1,2012-01-01,2012-07-01,1.00<br />
2,1,2012-07-01,null,1.50

PIEBALDconsult wrote:

Yet shouldn't there be some sort of an adjustment record th