SharePoint 2010 Web Parts missing ?

This is the place to go: http://<server name>/_layouts/NewDwp.aspx.

From the list, choose the web part you need and then click on "Populate Gallery".

The web part gallery will then be populated. You can access it at http://<server name>/_catalogs/wp/Forms/AllItems.aspx

How to filter a lookup column in SharePoint 2010 ?

A very good article that made my day today :-).

http://sprider.org/2012/05/10/how-to-filter-a-lookup-column-in-sharepoint/

Useful if you cant use InfoPath 2010.

But 1 day later, I found the below method cleaner and better

http://nagendra-gunaga.blogspot.com/2012/04/how-to-implement-cascaded-dropdown-list.html