Veracross has added a icon that will now show up in a query design if you select a field that will cause multiple records to be returned. The purpose it to let you know before you run your query, that you may want to modify your query, due to the fact that it might duplicate results based on a search field chosen.
Example:
If you run a find People query and add the “Degree” field, to your query, you will see the red icon appear. This is because if anyone has multiple degrees, they will show up more than once in your result.
That “Degree” field has what we technically refer to as a “one-to-many” relationship with people (because one person could have many degrees). 
Two records were returned for Brian, because he has 2 degrees.
