Hello Landon,

This is a bit confusing, but let me try to explain.

An Identifier is a Data Type by itself. So, the ComissionID, that I presume is an Identifier for the Comission Entity, is the Data Type Comissiong Identifier. The "underlining" data type is an integer, but when comparing variables/attributes that have an Identifier data type with something else, the platform does not use the "underlining" data type, to be able to detect wrong comparisons (e.g. ComissionID = OrderID, even if both are integers, would probably be an error).

Hope this helps clarify why you are getting this warning.

You can safely ignore this warning in this specific situation.

Cheers.

This warning occurs because you are comparing a identifier (which is of the type integer) with a integer. One way to solve this is, as Denis said, to use the IntegerToIdentifier function to convert the integer to an identifier.

A better way would be to take a look at cause of the warning.

I don't know the exact structure of your application, but there probably is (well, should be) a one-to-one or one-to-many between the Commission and CommissionAPI tables, based on the CommissionID field. To make this relation, change the datatype of the CommissionID field in the CommissionAPI table to Commission Identifier. This creates a foreign key between the tables and will solve the warning.

Thanks for all the replies!

Before seeing your response Eduardo, I already threw some IntegerToIdentifier() calls in there, and upon testing things seem to be working as expected.

Thanks again!

Glad everything is working as expected now :)
Cheers!

Here is the video guideline for solving this issue: https://www.youtube.com/watch?v=V4ZxSB6eX-0