I
ItsMeTC
Hello all, I have been trying to replicate a similiar solution I used in
Infopath2003.
I used script to query data from a webservice into a repeating table, the
user would select a one of the records to load into the form. I am trying
obtain the same end result but not sure the best route to take...any
help/direction provided would be GREATLY appreciated.
I would like to attempt without code but think that might be my only option.
1. Create infopath form bind to secondary SQL datasource (OwnersInfoDB)
2 On form - text field- user enters "OwnersID" and "Month" (as MMMYYYY)
3. Use user entry (Owners ID and Month) to query secondary datasource
4. Query return "Owner Info Summary" Records (four fields) for the month
selected
5. User selects "one" of the returned records; LOAD "Owner Info Detail" (20
fields) into the form.
If using code...can you recommend if I should use script or managed code and
the benefit.
Additionally is there a limit on number records a query can handle? I need
to determine if i should sepearte the Owners Info by year to spend up the
query and/or add an index(es) to the secondary datasource.
Infopath2003.
I used script to query data from a webservice into a repeating table, the
user would select a one of the records to load into the form. I am trying
obtain the same end result but not sure the best route to take...any
help/direction provided would be GREATLY appreciated.
I would like to attempt without code but think that might be my only option.
1. Create infopath form bind to secondary SQL datasource (OwnersInfoDB)
2 On form - text field- user enters "OwnersID" and "Month" (as MMMYYYY)
3. Use user entry (Owners ID and Month) to query secondary datasource
4. Query return "Owner Info Summary" Records (four fields) for the month
selected
5. User selects "one" of the returned records; LOAD "Owner Info Detail" (20
fields) into the form.
If using code...can you recommend if I should use script or managed code and
the benefit.
Additionally is there a limit on number records a query can handle? I need
to determine if i should sepearte the Owners Info by year to spend up the
query and/or add an index(es) to the secondary datasource.