Data exchange between two tables

Hello @gio and Tulip Community,

I would like to create an app where , if a part is found defective in the “table of parts”, I would like to move this part’s serial no. into another table called the “Defective parts table” and the new part no. will be entered into its place in the “Table of parts”.
Will I be able perform this in Tulip ? I tried Linking the tables and also tried giving the command “Table Records - create or Load record” but these haven’t given me the expected result.