https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/123361.aspxFri, 21 Aug 2020 15:51:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123361Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123361.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123361Sounds like you have your setup basically correct - you should drag the secondary data source onto the form so you can see the data. Is ID number a number data type? It could be that added decimals are causing an issue.https://www.infopathdev.com:443/forums/thread/123358.aspxThu, 20 Aug 2020 20:24:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123358hjsh010https://www.infopathdev.com:443/forums/thread/123358.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123358Hi all, I am trying to create some fields that can auto generate the data that matches the sharepoint list that I have My goal is when the user keyed in their ID no. into the "ID no." field, their full name is auto populated to "full name" field. 1. I have a 2 text field "ID no.", "full name" 2. I have a sharepoint list that maintain the ID No. and full name. 3. I have added data connection to the form for my sharepoint list 4. I set a formula for the default value on "full name" -> Insert field section i selected secondary data source -> i selected full name field to be populated -> i select filter data -> add a condition where ID No. = "ID No." Seeking your help to clarify if there is any wrong, as I can't get my goal. Thanks!