>
>Let's see if I understand what you mean.
>
>1) You have a Customer file whith general info. Each customer has an Account Number.
>
>2) You have a properties (pages?) file which has a foreign key to the customer (i.e. the account numeber). Index on the foreign key for speed. Each property receives a number as it is created which has no special meaning, but that you can use to determine the order in which they were created (i.e. previous/next).
>
>3) Instead of keping track of the number of pages you actually count them each time you need to know.
>
>Hope this helps,
>
>Alex


Actually, that's what I am doing now (except I'm only using one table). Opening the file in another area, counting the records which have the same account number and then determining by counting until I reach the record has the same record number I am currently on do determine the current page. But I was wondering if anyone had a more efficient way of handling this.