I'm using one file that contains portals and relationship into several others. I do all my data entry and reporting from this one file. I want to use first, previous,next and last buttons to navigate. I also want a field that reports the current record number of the related file I'm browsing. My main problem is a relationship: GlobalReccordNum::CalcRecordNum If I change the calculation field to Unstored: Status( CurrentRecordNumber) my relationship won't work. Any suggestions.

The obvious answer is to not change it to unstored. Since you haven't let us in to the secret of why you need the calculation to be unstored, it's a little hard to advise you what to do.

Also be advised that Status(CurrentRecordNumber) is not a constant for each record in you related file. It is the position of a reocord in the current found set given the current sort order and can change any time the found set or sort order changes. If you wish a given number (say 5) to always point to the same record in the related file, this will not be the case. If you want a constant record number, you can set one with an auto entered serial number or use Status(CurrentRecordID), which does not change.

-bd

The CalcRecordNum field Status( CurrentRecordNumber) is unstored because I had duplicate numbers when it was stored (as records are deleted). If there are 10 records I need those records in that field to contain the numbers 1-10. Right now I'm using a script that runs everytime a record is created or deleted - it goes to the first record then Replaces starting with 1and increments by 1. It seems to work but I'm not sure if this will slow things when the database grows.