find a records position in a table

[abbers_01]

Is there a way, aside from using auto number, to find a records postion. I am using a list and want to be able to double click an entry and have it open a form and go to that record. However I can't use auto number because I allow for the deleting of records, and once deleted the auto number no longer corrilates to the records position.

If anyone knows of a different sytem that renumbers after deleting a record that would be great if you could share it with me. Or if there is a way to open a form and use goto record but instead of using record postion use where statement.

If anyone has any other ideas on this please share. Thanks.

 

[KenHigg]

a. Trying have a record position type field in a table where the value correlates to where the record physically exists in table is in a word bad juju. The closest thing you should do to mimic this is to have a field that stores the date and time the record is created...
b. You can do what you need by using the primary key field in form one as a filter for form two...

 

[Brianwarnock]

Couldn't you simply use filter by form?

Brian

 

[Guus2005]

Use the Autonumber field as a primary key to which you can connect the other tables. Create a sequence field (SeqID) for the sequence of your record.
When you delete a record there is a gap in your autonumber sequence as well as your SeqID sequence. You have to create a procedure that loops through all records in the sequence of the Autonumber field. When you do that, update the SeqID all the way to the end. The SeqID is now resequenced/renumbered.

Actually knowing where your record is located in the table doesn't make any sense.

HTH

 

[KenHigg]

HTH

Had to google HTH to figure out it stood for

 

[abbers_01]

Thanks for all you input, I always seem to make thing harder than they need to be, the filter did the job, while I am new to this I had used it before and just forgot about it. I like the idea of the auto number and sequencial number i'm test that out because I have done quite abit with autonumber and I think that method could be very useful for me.

Thanks again to everyone.