Dynamics Community Forum Thread Details

Create record from lookup field if record is not found

Hello!

I am currently working with a lookup field, and is on the lookout for a solution to a problem I have, or at least see if there is a way to make it smoother for the user.

Working with other lookup fields, I am able to press the "New" button in the little popup table, and create a new record that way, but in the current lookup, I am facing an issue.

As you can see in the pictures below, I am not able to insert a value that does not exist in the table. In this case, that is the Dimension Value table. I know I can insert data into that table, but that is not what I am asking.

Is it possible to run a procedure, or anything before or after that error occurs, where I can ask the user if they want to insert the value into the table? Are there any triggers or anything I can listen to?

The field itself is just a normal Code[20] field with a TableRelation. It also has an OnValidate trigger, but I am pretty sure I don't get that far unless the value is okay.