Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6862 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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. ???

Posted

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

Posted

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!

Posted

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:

This topic is 6862 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.