You can do this by using import records to copy the record along with delete record to remove the original.
However, this is a risky thing to do and usually is not necessary.
Why do you want to move the record in this way?
Well we have an association with members..
So i have a members table who are member.
and i have created a table with people who have sign out of our membership.
so i want to have the record from that user who wants to sign out to move it to the table from the members who sign out.
(and at the same time it needed to be deleted in the Membership table)
Can you maybe explain more detailed?...
A simpler approach is to add a field to your table that identifies the member as either a "current" or "former" member. To see a member ship list, perform a find for just "current" members. To see list of "former" members, perform a find for "former" members.
That way there's no need to move or delete records.