InfoPath Dev

I've been having a problem with the unique filter code as stated in this thread:

http://infopathdev.com/forums/topic.asp?TOPIC_ID=3506

So I came up with an idea for a work around. I created another secondary datasource that queried the Lookup datasource. It created alias fields that joined two fields. In the thread from before, it combined Type and Area fields into one field, TypeArea. My idea was to then use this field to apply the unique filter on. However, I have discovered, that the only way a unique filter will work is IF AND ONLY IF the lookup entries are bound to a specific column (not the table) AND the unique filter is applied to only that selected column.

Please confirm....

Hi Trufooser,

I'm not exactly sure of your situation here, but it seems like are you running into some of the difficulties in working with secondary data connections in InfoPath. It is true that complex relationships from relational database tables are hard to manipulate in InfoPath, but without more information about your specific scenario we cannot confirm your claim.