https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/2839.aspxMon, 24 Jul 2006 16:50:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:2839Taffman0https://www.infopathdev.com:443/forums/thread/2839.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=2839Many thanks but this isnt exactly what I'm after.<br /><br />Imagine a financial for where there is a different fiancial Cost Centre Code for each country and each sales channel in that country.<br /><br />Now the Country and Sales Channel will have been selected by the user in an earlier view.<br /><br />What I want in the view in question is to return the cost center that belongs to the country and sales channel previously selected.<br /><br />Does this make sense?https://www.infopathdev.com:443/forums/thread/2838.aspxMon, 24 Jul 2006 16:39:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:2838Kalyan Gaddam0https://www.infopathdev.com:443/forums/thread/2838.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=2838Hello <br /><br />Using Conditional formatting, Hide the field into which you have the Populated value. Use the Conditions to hide the field that as long as the other 2 fields are blank and not equal to Similar fields. Only when the 2 fields are equal to the similar fields the populated field will be shown.<br /><br />Hope this will help you.https://www.infopathdev.com:443/forums/thread/1436.aspxMon, 24 Jul 2006 16:20:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1436Taffman0https://www.infopathdev.com:443/forums/thread/1436.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1436I'm trying to populate a field with a value from a sceondary datasource depending on the value in two other fields equaling simular fields in the main datasource.<br /><br />I dont want to use repeating tables with filter criteria on field 1 and field 2 as this requires field 1 data being selected on the Form twice.<br /><br />What I'm looking for is either a lookup function or some kind of IF statement.<br /><br />Does anyone have any ideas?<br /><br />