SQL Database Integration

Re: Add a supporter and refresh drop down list

Howard — Fri, 22 Oct 2010 16:22:17 GMT

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

Re: Add a supporter and refresh drop down list

Howard — Thu, 21 Oct 2010 16:45:22 GMT

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

Re: Add a supporter and refresh drop down list

Hilary Stoupa — Thu, 21 Oct 2010 00:29:10 GMT

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?

Add a supporter and refresh drop down list

Howard — Thu, 21 Oct 2010 00:03:06 GMT

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