I realize size may play a big part in the choices here, but im not even sure of what all the choices are. If you wanted to create a backbone, or subordinate sets of lists, or data tables, that you will be using as data connections to a family of forms, or even more then that…as part of an entire business intelligence project that you may want to create measurements from, or run custom reports or dashboards from…. what are all the options?
a bank of lists that are more easily edited by departmental management instead of IT.
or an access database manged elsewhere and republished as its updated?
Im just beginning to look under this rock, and im having to sit down and wonder about this stuff before we jump right in and make a dozen lists with 20 columns, and wish i’d done something different later down the road.
Im not well versed in much code yet, but im ok with infopath forms…connecting to web services or other local sharepoint data connections is really my only experience with forms… you make a few nice forms for somebody and boom, next thing ya know ideas of grandeur start to get thrown at ya =P
