May 12, 200223 yr I have a database that uses a field that auto-enters a serial number in a field everytime a nw record is created. Would there be a way to create a script that would go to the record where the field named "serial" contains te highest number? LR
May 12, 200223 yr The highest numbered record is always the last record entered: Show All Records <--- if you mean THE the highest number, leave out for "in the current found set" Unsort Go to Record/Request/Page (Last) -bd
May 12, 200223 yr If it's not always the last record, you could use the script Sort [by serial number, descending] Go to record [first]
May 14, 200223 yr Sounds like you're looking for something fancier, so here you go. Create the following: 1. A calculated field "constant" that = 1 2. A self-join, "constant," that is constant::constant 3. A calculated field "theMax" that = Max(constant::serial number) 4. A self-join, "eureka," that is theMax::serial number 5. Now make a script and/or button to Go To Related Record (eureka)
Create an account or sign in to comment