insert data to other data source

[ri_jin]

i have 2 tables table A and B . from table A i get temp employs data it selected to a form and if i click submit option i want to insert  this form to table B .

[eka24 · Accepted solution]

You can use the Patch function;

Watch this tutorial;

https://youtu.be/jvdsr6THUQo

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[ri_jin]

Patch(Table1_4,Defaults(Table1_4),{employeid:employeid_DataCard7.Text,employename:employename_DataCard7.Text,salary:salary_DataCard7.Text })

i try with this syntax but it shows error

table1_4 is the table which i want to insert this data cards

[eka24 · Accepted solution]

Instead of Datacard, Use the datacardvalues. Datacardvalues are the textboxes that holds what you enter on the form.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[eka24]

Is it now ok?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[ri_jin]

yes it is working thanks

[eka24 · Accepted solution]

Please mark as a solution.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.