Record number doesn't match

[Storm Cellar]

Hi. How can be sure that the record number (defined field) matches the record number under the flip book on the upper left hand column? Have tried for 8 hours, but no luck. Thanks!

[CobaltSky]

Since records can be sorted and omitted (eg via a find) - not to mention deleted, stored values in a field will change their position or order from time to time.

If you want a field to always show the position of the record in the current found set, try creating an unstored calculation with the formula:

Get(RecordNumber)

Or alternatively, just place a text object into the layout body part with @@ in it - and this will automatically display the current record number in browse mode. ???

[Genx]

At first i thought this was de ja vu, or however you spell it lol: you posted this question 5 days ago Storm Cellar and Ender gave you exactly the same answer. (Topic#174274)

~Genx

[Lee Smith]

I have sent a private topic to Storm about not double posting.

Lee

[Storm Cellar]

Hi. Thanks for the answers! Sorry about the double post! Still learning how to use this system. Storm Cellar

[Storm Cellar]

Hi. I want the user to be able to click on the Record number: box below the book in the left hand column, enter a number, and navigate to the correct record (assume they've made a "hard copy" report of all their inventory and the associated record numbers). However, as soon as a user deletes a record, the record numbers change, and now the record number that is in their documentation doesn't match the correct item/record, and when they try to navigate quickly with the book icon, they go to the wrong record. Sorry about the confusion. I should have been more specific. Thanks in advance!

[CobaltSky]

Hi Storm Cellar,

For the reasons explained above, you are not going to be able to use the field in the Status Area (the gray band at the left) to achieve the functionality you require.

There are, however, a number of alternative ways to set a database up to achieve what you've described you've described. Here is one:

1. Create a global field of the same data type as the record number (or serial number) field in your table.

2. Create an additional occurrence of the table on the Relationships Graph (in the Define Database dialog) and draw a relationship between the global field in the original Table Occurrence (TO) and the record number field in the new TO.

3. Place the global field into the header part on your layout.

4. Place a button next to the global field and attach it to the Go To Related Record[ ] command.

5. In the "Specify..." dialog for the Go To Related Record command, select the new TO you created at step 2 and specify Using: Current Layout.

6. Label the button 'Go' or 'Locate By Number' or somesuch...

With this arrangement, when users enter a record serial number into the global field and click on the button, they will be taken to that record, regardless of where it is in the file. :wink2:

[Storm Cellar]

IT WORKED! Thank you so much!! I've been looking for a solution for 3 months! Gratefully yours, Terri