Is there a way to handle table record creation error (eg.: I want to insert same value in ID field that already exist.
User can create record based on values from other tables (SkuId and LineTypeId). I’m using combination of these two fields to create unique ID in another table - for this case is not important for what this table is used.
User can then edit data if record based on unique Id (SkuID + LineTypeId) is already in table (showing edit step) or add new record (using Add step) if record does not exists.
So it can and will happen that user will use Add step and step will show error that Id already exists. I would like to close (or not open Add step in the first place) if created record produces error (id already exists).
So long question short: Can create record error can be handled in triggers? This functionality is useful in various scenarios.