Hi

For example, if I have 10 records with a priority field so record 1 is priority 1, record 2 is 2 etc. then I change say record 5 to priority 1, it will automatically change old priority 1 to 2, 2 to 3,etc. Thanks

First of all YOU need to really think through how this will work and write out your logic in pseudo-code (basically a normal language process of what will happen, with as much application specific code as you know).

For instance:

User Changes Priority

Goto First Record

Loop

Set New Priority

Goto Next Record [Exit After Last]

End Loop

Or whatever. You really need to think this logic through, because I am not sure that you really want to do what you are saying that you want to do.

Once you have the actual logic worked out and the pseudo-code written, you should be able to convert it to Filemaker scripting pretty easily. Or you will have more specific questions to ask.