What is the best control to use...

[RachelD]

I have a sharepoint list that will have at least 1000 entries. There are 16
divisions and under each of those divsions, it has at least up to 100
descriptions with a number code. I need a repeating table to allow the user
to choose which division they need, and pick a description with code, and
then the dollar amt. The total will be automated in the repeating table.
What is the recommendation on handling a huge list and being able let them
choose any division and choose a code they need. I am a newbie and learning
the ins and outs of infopath 2007 and moss 2007. Thank you for your time.

 

[Clay Fox]

Hi Rachel.
Welcome to the wonderful world of InfoPath.

Ideally, due to the large list, I would recommend using web services and a
database for performance reasons. You may want to investigate the Database
Accelerator from http://www.qdabra.com. It provides what you need in an
installable package to add dynamic queries and submits to database data. It
also can integrate with SharePoint and provide the data there. It would also
allow you to report on the data collected and analyze it via Excel or Web
Report.

Anyway, typically you would build the repeating table in your form. Then use
dropdown controls bound to your list data to select the division and code.
The user would enter the dollar amount and then insert another row as needed.

If you need additional help let me know.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[RachelD]

I don't know if this will make any difference. Its a very small company
that is using this list, so ideally about 12 people will be using this list
at sporadic times. There is no sql db except for the moss 2007 to run on.
I am limited on what i need to do and the budget is very tight. I am told
to do the best I can to make it work. Webservices, again, I am very new to
web development and stuff, does it have to be web service? Thanks for your
time.

 

[Clay Fox]

Yah i know how that is.
The web services could be installed right on the MOSS server. The
webservices can be used codeless in InfoPath so it makes it nice for form
developers.

I do not see anything in what you describe that would require web services.
Web Services would just make it perform better and have more capabilities. I
am not sure what your exact deliverables are.

If you need some training or consulting help, you can purchase a couple
credits for some time with an InfoPath MVP from the store at
http://www.qdabra.com/products_all.asp?cat=12


--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com