I have to say that I am impressed with the way Sharepoint 2010 handles lists, lookups and columns. It now has the concurrency ability whereby – if turned on/selected – if you perform a lookup on a data from another list and you try to delete that data, Sharepoint will not allow you to.

See below for screenshot:

Lookup field settings page

Error when trying to delete an item that’s referenced by other list

Plus, you can now view multiple columns of the looked-up data (EXCELLENT!). See below:

So yeah..I have to say that I will definitely upgrade to SP2010 once the released version is available! 🙂 It definitely eliminates a lot of problems that I (and other clients) are having at the moment with columns and content types.

Cheers,

Tommy