I am using Microsoft Infopath to try and create a front end for a access database. I have a data source which stores an id number for the customer. This id number relates to a secondary data source called tblUsers. the id field then relates to the users forename, surname, email address etc. When the customer id is selcted in a drop down list box, the email address is shown in the box using the secondary data source.
What I need to do is use the display name of the drop down box, not the value, to populate another expression box. I have the following Xpath. Does anyone know where I am going wrong.
xdXDocument:GetDOM("tblUsers")/dfs:myFields/dfs:dataFields/d:qryAllUsers/@email1[xdXDocument:GetDOM("tblUsers")/dfs:myFields/dfs:dataFields/d:qryAllUsers/@ID = dfs:dataFields/d:tblOrders/@_customerid]