How to update a user selected record from one table to another

[Anonymous]

Hi,

I have Source Table A with Column A, B, C, D and Source Table B with Column A & B. I want to create a button action that allows the user to select from Table A and transfer that record's Column A *& B values to Table B.

Is this possible? Can someone share how can I do this. Example would be great!

rgds,

Nickson

[#2]

Hi Nickson,

I dont understand very well your requirements, can you explain this with more detail or with an example with some data?

Regards.

[Anonymous]

Ok... here's an example.

Table A

A    B            C           D

1    Apple      Red        10

2    Orange    Orange   5

... many more records...

When user select on say A and then click on an action button "Put to my basket", the record get transferred to Table B. If he does it also for the orange, then Table B would look like the below.

Table B

A    B

1     Apple

2     Orange

Hope this is clear now.