I am in a MOSS07 environment and i have INFOPATH 2007 as well as SPD07.
I have created an INFOPATH form to post to a custom list. That works great. My challenge is to use the same form to query existing data.
I have made it quite simple for proof of concept.
FirstName
LastName
SSN
I want to be able to search on LastName or SSN and have the fields populated if record exists.
I am not a developer. I am a sharepoint server administrator that has been thrust into user experience as well.