error adding 1 row of table to another table

[Kaushal_Didwani]

We have 2 tables, 1 for sale order and 1 for purchase order. We have an automation if a user enters a sale order and if he wants to raise a Purchase order then he can do so,

We have Clientn Name as enum list (base type:Text) with data validity of Customer Master added in both purchase and sale order tables.

However an error is coming when the data is getting added saying: Perform DataAction 'Add in Jobber Table' failed because Row having key '07/26/2022 18:07:24' in table 'Jobber Order' containing value 'P1, P2 ' in field 'Customer Name' failed 'Valid_If' condition.

[dbaum]

You may need to make your Customer Name columns a Ref type (it could be an Enum type with Ref base type) and based them on the Customer Master table's key column rather than that table's column for the actual customer name.

If this isn't the issue, I suggest you post screenshots of the list of columns in your Customer Master table and the column properties of each Customer Name column in the other tables.