I have items I would like to store in Sharepoint lists and am having a hard time finding the best way to do this.
The criteria are:
1. Need a rapid way to enter information (such as is possible with datasheet view)
2. Need certain columns in the content type to be consistent.. Either from an External Lists (from our LOB system) or managed metadata.
Those two criteria seem to be at odds with each other. Using an external list would really be nice because I can keep certain field’s relational data intact, however I can't
use datasheet view. Datasheet view is important because it allows copy and paste/tab through data entry when many rows must be entered.