What is the easiest way to swap the contents of two records?
I have a table that is related to another table. The record's number in this table is very important. i.e. the first record has a priority over other records and etc.
any help would be very really appreciated,