InfoPath Dev

it is a DB Connection, but I filter data in numerous places (to set fields values for instance) and have no issues whatsoever. I ended up changing the database structure so that the validation is based on one field only - I needed to finish lol. I absolutely love this application and have developed many useful forms ... but I would be soooo much ...

I tried both of them, and then one at a time. For some reason they are always 'true'. A different attempt was to modify the data connection such that I only have one field to filter by the SQL was modified to select [Project] & ''-'' & [CostCode] AS ProjectCostCode and this was validated against this function ... concat(current()/@Project, ...

I was trying to validate a drop down box entry versus a secondary connection that requires 2 filters, i.e. the selected cost code must be in the validation table FOR THE SELECTED PROJECT. The reason for the validation is that the validation table may change prior to submitting the form. The following expression ALWAYS indicates bad data ...