Hi there,

After performing a search in table A, I'd like to move the result to table B.

I tried different scripts such as...

New Record/Request

Set Field (Table B::Global Member ID; Table A::Member ID)

Set Field (Table B::Member ID; Table B::Global Member ID)

with no success

If there is a relationship between table A and B then use the Go to Related Record script step.

The relationship is based on the Member ID. Adding the new command gave me an empty record.

What exactly do you mean by "move the result"?

I don't want to move all the records. Just the records from the search.

See the attachment

Again

Member Roster.zip

What is the purpose here? As a rule, the regular operation of a solution should not require moving records between tables. Nor should you have two tables for alike records.

Attachment failed decompression for me.

imho, a red flag is raised when you want to move data from one table to another. Why do you feel the need to do that? Are you archiving somehow?

Edit: LOL, good morning, Comment!

I don't want to go deep here but I got complex information to filter. Here is again the attachment.

Member Roster.zip

Well, technically you could import the found set to another table, then delete it in the original.

However, I would suggest you reconsider your approach to [whatever it is you're trying to do...].