InfoPath Dev

I have a form with 3 fields,

Field 1: Drop Down Customer List

Field 2: State based on lookup table from Customer Drop Down List

Field 3: Sharepoint Data Connection Address based on lookup table from Customer Drop Down List

The i have a submit Button,

Customer = TEST1

State = NSW

Connection = https://www.sharepoint.com/test1_update 

SUBMIT BUTTON

How can i make the data connection in the submit button take the address from field 3, i have over 60 customers so 60 different datac onnections, the Custoemr list,state and data connections all come from a customer master list on my sharepoint site.

Hi,

I think that our qRules tool can help you out here.  There is a command called "ChangeSubmitUrl" (read this: http://www.infopathdev.com/files/folders/qrules/entry52999.aspx) that might do the trick for you.

qRules is $199 and available here: http://www.qdabra.com/en/products/qRules.aspx

Ted