Richard Thomas

Thanks. That's really helpful.

I have a database of 185 records. The record numbers are currently in a text field 'record no', Indexed, Auto-enter Serial, Required Value and Unique. When I sort on record no, the order result is not serial but reads the first digit, so record no 3 is followed by record no 30, then 31, etc, 39 is followed by 4, etc, as it should in a text field. However, I want to sort 1 - 180, so presumably need to change the field from text to numbers. How can I do this without losing the data?

Yesss!!!! Thank you so much. That solved the problem. FMPro is a great bit of software, and so often the problems that cause you headaches are resolved by what should be obvious logic. Again, thanks.

Script below produces attached rubbish output. Have tried creating new file from Excel data, but same result. Mac Mini Apple M1 running Ventura 13.4 How do I correct this please? 1. Show all records 2. Go to Record/Request/Page [First] 3. Save a Copy as [file:Reg14 File IN USE BACKUP; copy of current file; Create folders:Off] 4. Close File [Current File] Produces file output attached, not a copy of FMPro file: Reg14 File IN USE BACKUP

Thank you! Beautifully solved by changing from popup to dropdown. Nice one.

I have an address record with seven fields. To enter the data, my users like to tab through the fields in a set order. One of the fields is set to pop up list with a value list of world countries, the first of which is 'United Kingdom'. My problem is that if I click in the field with the mouse, the popup is triggered and the value list is displayed for selection with the mouse. However, if I tab through the list, when I tab into the field the popup is not triggered so the value list of countries is not displayed for selection. How can I set the layout so that tabbing into that field will show the popup list?

A simple script to close the file, saving a copy for backup, fails to log the user out. Each time I open the file after the initial opening, the login and password request is bypassed. Simple file closing script: 1. Flush Cache to Disk 2. Save a Copy As ... 3. Close File When I re-open the file, I am NOT asked for my login details. I need the re-opened file to ask for login and password on each opening. Simple opening script reads: 1. Go to Layout 2. Adjust Window 3. Show all Records Question: What do I need to add to either of these scripts to force FM Pro 18 to ask for login details every time the file opens? I can't find the answer anywhere.