I have linked tables and created an action in parent table " New Cheque" to add a new row to child table.
Then I have created a new action of “execute an action on set of rows” to invoke the " New Cheque" action in form saved of parent form.
the intention is to copy some row from the parent and set some formulas with other that were not intended to be copied.
i set my child table key with initial value of [Unique ID].
after saved, i keep getting this error of Failed action due to “there is already a row with the key”.
what am i doing wrong here?
thanks for the input