InfoPath Dev

Hi, InfoPath 2007 has turned into a fantastic data entry tool for my SQL Server database.

 I'd like to ask a question that would put my form over the top.

I have a form to fill in database supporters. There is a drop down list that queries a secondary data source and pulls in the supporter names. Sometimes I fill in my form and when I get to the supporter name, I notice that I forgot to add a person to the supporters table so they are not in the drop down list.

As a result, I have been closing the database form and opening my "add a supporter" form and adding the person then reopening my database list form and filling it out again.

It would be great if I had an easier way to add a supporter and then refresh the drop downlist on my database form so it includes the new supporter. Is this possible? Can I build an "add supporter" section or view into my database form?

Thanks for the guidence.

Howard

Hi:

Couldn't you use a hyperlink with the URL of your Supporter form, and then have a "refresh" button next to the dropdown that re-queried the 2ds for the dropdown?

So, the user would click the "Create New Supporter" link, it opens the form, they fill it out, submit, then click the refresh button (use one of the *ding fonts that has little pictures for your button, and you can even have a little refresh symbol) and that runs the query for your supporters table.... Does that make sense?

It does make sense. I went ahead and set it up that way.  I was hoping to do it all in the same .xsn file so I would only have to publish once but this works too. Can't test it until I'm given a location to publish but I see the url so no doubt it will work.

Thanks for your help Hilary.

Howard

This worked perfectly Hilary. The other form is opened from a url and then after pressing the refresh button, the new name appears in the list.

Thanks,

Howard