InfoPath Dev

I have been mulling this over for about a week and can't seem to come up with a logical approach. I have ID#'s stored in two different fields in a SQL database; fields a1 and b1. Normally I would have a1 in the IP query box and that would search a1.  A nice 1 for 1 relationship. But now I (actually my end users) would like one ...

 Interesting issue. A Google search revealed some very interesting things I was not aware ...

In your InfoPath form, wouldn't it be possible to make the fields required? I think that's possibly the easiest solution, to force users to fill in that field. Good luck!

 Buenas Tardes, estoy realizando un diseño de sharepoint. En el tengo bastantes datos almacenados , con sus respectivas vistas y demas. Pero me gustaria realizar un mini formulario sencillo de busqueda datos. en el que tendria 5 campos como max (AÑO,EDAD,...) para que me sacara un listado de aquellos datos que tengo almacenado en ...

 I have put comment but it will show my:comment and still not working. Any idea?

Hi Patrick, i'm trying to send an excel file as attachment but i'm unable to set "AttachmentFileName" to my file's path. it says it is read only. i'm using infopath 2007.  please help. Urgent!!

Correct  ...and it indeed works when changing the Compatibility Settings.  I guess then there is no way to set focus in a browser enabled form...  Thanks!

Add a manager field, and use it in the 'To' field. When a user selects a department, automatically update the manager field with the department manager (you need to do some lookup for this). Hope that helps!  

Hi William, Click on the options tab, and click Add/Update button to attach your form template. Regarding the error message, can you check your SharePoint log files for any exception?