Storm Cellar Posted February 24, 2006 Posted February 24, 2006 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 Posted February 24, 2006 Posted February 24, 2006 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 Posted February 25, 2006 Posted February 25, 2006 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 Posted February 25, 2006 Posted February 25, 2006 I have sent a private topic to Storm about not double posting. Lee
Storm Cellar Posted February 26, 2006 Author Posted February 26, 2006 Hi. Thanks for the answers! Sorry about the double post! Still learning how to use this system. Storm Cellar
Storm Cellar Posted February 26, 2006 Author Posted February 26, 2006 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 Posted February 26, 2006 Posted February 26, 2006 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 Posted February 26, 2006 Author Posted February 26, 2006 IT WORKED! Thank you so much!! I've been looking for a solution for 3 months! Gratefully yours, Terri
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now