Impossible in list view?
Well, I don´t know if what I want its possible in List view. The thing is, I want to be able to move a record above or on top of another record with a button. It´s is possible?
Yes, you can reset the auto-enter serial using a script. Use the command:
Replace Field Contents [No dialog; <auto-enter serial field>; Serial numbers ]
Set the serial number option to "Custom Values" and put in the initial value.
In List View
You can view ALL records or a subset
The records can be unsorted or sorted by one or more fields
If you view all records
AND sort by a field for List View Order
you could switch the contents of the field with the contents of a record below or above
So, yes, sorta.
There may be a more sophisticated solution, this would be easy. Given the restrictions.
That sounds promising, can you explain it a little bit further? please?
Thanks in advance.
Thank you for your post.
In your Header, create a graphic and format it to be a button. Have the button sort the file by the field you want. Then, when you add the record, click this button, and it will display in the appropriate position.
Hi, thanks for the answer, I was trying with a button and a script, the script goes like this:
sort records [ restore, SortOrder ascending , no dialog ]
But when I delete a record the script no longer work...
If you delete a record, there is no reason why the script wouldn't work. The worst that could happen is that you have a gap in the numbering sequence, but the data would still be there. What is occurring? From your example script, how is SortOrder entered? If nothing is entered, then you could have a negative result (-1) and the record would be listed first.
The SortOrder it´s an autoserial number field..
Thank you for the additional information. However, you still haven't told me what is occurring. The only possible problem I see is having two records having the same SortOrder value, but other than that, it should work fine.
Thank´s!!! While I was coping the scritp to explain a little bit further the problem I have... Well I discovered a missing part on the script... so big thanks for helping me out.
So I have another consult to make, while the last was my first concern, I have another issue, my database consist in two files related a FileA and a FileB, but I need to, very often, create a clon file from FileB and place it in other directory, let´s say the desktop, but when I do that, the FileB cloned can´t find the FileA anymore, even if the FileA it´s already open...I´ve tried everything with the File References dialog.
One more time thanks in advance..
The Clone of File B has lost the reference to the File A. Therefore, remove the reference and recreate the reference.
Thanks.... for the quick response!:)
How I avoid the loss of the reference? I´ve have to do it with every file?
And one last thing... Is there a way to reset to 0 an auto-entered serial number? Without the Layout Mode?
The reference runs both ways. FileA is related to FileB, and FileB is related to FileA. If you make a clone, the relationship still exists, and the relationship expects the tables to be in the expected directories. If you move one of the files, the relationship may need to be reset. Making a clone of the file still leaves the original file in the same location.
To reset an auto-enter serial number field, simply go into "Manage -> Database", select the Fields tab, double-click the field in question, and change the starting number back to 1 (or zero).
Great explanation for the reference, I will find another way to do it.
And, can I reset the auto-enter serial using an script?
Retrieving data ...