Moving records from table A to B

[Bikeman17]

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

[Vaughan]

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

[Bikeman17]

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

[Vaughan]

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

[Bikeman17]

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

[Bikeman17]

See the attachment

[Bikeman17]

Again

Member Roster.zip

[comment]

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.

[bcooney]

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!

[Bikeman17]

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

Member Roster.zip

[comment]

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...].