InfoPath Dev

Thanks for the suggestion, but with 500+ items that is not acceptable in this case.

I'm having some problems with getting validation to work against a secondary data source, in this case a field in a SQL table. My situation is that I have a SQL table with say 500 records, with a column for ProductCode, what I want is a text field on the InfoPath form (e.g. TextField) that allows the user to type in the product ...