Bot for copy data from parent to child table based on condition

[Michael_at_Graz]

Hello everybody.

iam confused and i need a little help.

i have a parent table "Aufträge" with the column [Artikel Lock] that Column is set automaticly with an initial value, based on a condition, to "ja" or its blank. 

On the Other side, i have a Child Table called "Artikel Aufträge" with an column [Lock].

I made a bot, that is checking every change on the table Parents table "Aufträge" with the optional condition "[Artikel Lock]=ja and the bypass security filter is on. that bot should start the process "Run action on rows" on the reference table "Artikel Aufträge" reference rows "reladet artikel aufträges" referenced action "Lock auf ja".

The action "Lock auf ja" is an action for a record of the table "Artikel Aufträge" to do  this: set the values of some calumns in this row, [Lock] = ja.

everything looks fine, but the [Lock] on the child table is not set to "ja", if i create a new entry on the parent table. the [Artikel Lock] on the parent table is automaticly set to "ja".

i have no plan what wrong, cause in an other app, i set everything exactly the same and it work. the only difference between the tables, is, that the column [Artikel Lock] in the other app, dont have an initial value.

Maybe someone see a solution or my fault.

Many thanks in advance and nice greets from austria

[James_McFarlane]

Hi @Michael_at_Graz 

Have a look at these tips might help with what your are trying to accomplish.

Copy parent record together with child records ; Action Only, No API, No workflow 

Step-by-step parent child copying method. 

[Michael_at_Graz]

Many Thanks for your help, but still not working with any solution.

I solve the problem by adding a formula to the column "Lock" in the table "Artikel Aufträge" like this:

Lookup([_THISROW].[Auftrags ID],Aufträge,Auftrags ID,Artikel Lock)

also i change the view from the reladet artikel aufträge, so every change on the table "artikel aufträge" is only possible, if the user open the table "aufträge".

Nice greets from austria