InfoPath Dev

Hi Hilary Thanks for you reply. I had tried the checkbox for only returning unique values, but that did not fix the problem as the form first had to look at all the Access table's records and then remove duplicates. A colleague of mine managed to figure out what the problem was and a solution for it. The Access Table ...

I am in the process of creating an Infopath form which is connected to an Access Database. The database holds Oracle tables and queries – the queries simply collect all the data from the Oracle tables.   I have used 3 successive cascading drop downs on the Infopath form itself so that when picking a value from the first drop down, Infopath ...

Hi Jimmy  That works! Thanks, that's great :)

Hi Hilary, thanks for your reply, sorry I have only just seen it. The expression is . != xdXDocument:GetDOM("TOTALPLANT_OM_LIMIT_SET")/dfs:myFields/dfs:dataFields/d:TOTALPLANT_OM_LIMIT_SET_Query/@EQ_NAME  

I am building a form which is linked to an Access Database. I wish to create a text box which users will manually enter values into, and which a validation rule will then check against a field in an Access Table or Query. I managed this by adding a rule which has condition: field1 Is Not Equal to EQ_NAME  (where EQ_NAME is the name of the ...