I have two id fields. PriId and SecId. PriId is Autonumber and SecId I control. It's for a family tree website. The secondary number I created so when you sort by it it falls into family tree order (well something close because of all the divorces and ex's and stepkids, you should try it sometime 
). Is there a way in Access 2000 to sort it in the data entry view by that number (SecId) and then
re-sequence the Primary Key (Autonumber) to follow that order (1,2,3,4,5,6,7,8 etc.) so as to keep the records in their sequencial order and in family tree order and keep the database organized for working on it.
T.I.A.
Jack
). Is there a way in Access 2000 to sort it in the data entry view by that number (SecId) and thenre-sequence the Primary Key (Autonumber) to follow that order (1,2,3,4,5,6,7,8 etc.) so as to keep the records in their sequencial order and in family tree order and keep the database organized for working on it.
T.I.A.
Jack
