Related Navigation

[jfrick]

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.

[LiveOak]

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

[jfrick]

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.