I know there is a posting on this subject already, that is still active. But im trying to do something a little differant. This link
http://infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18fb2c5bac85 is almost close. BUT I would like them to have a text box for the user to type in a case number and click on button to retrieve the information. A dropdown box would be nice, but with the amount of records, it just times out. Now after they type in the number and click query I would like it to populate 4 boxs, pretty much what the form does in the link I provided. I'm using IP2007 , but IP2003 is available.