I like SharePoint Designer (aka FrontPage for SharePoint)...As we all know I have been designing websites since 1997, when I was 15 years old. FrontPage and Dreamweaver were my friends after high school, so I know the good and the bad sides of the programs. Today I was attempting to use a custom edit form in SharePoint Designer and a datasource linked to a list. For the life of me I could not get it to work, so I spent a little portion of the day on Google looking for another option. I found a little post where Paul Galvin has spread some of his SharePoint awesomeness in SharePoint Universities Forms (http://www.sharepointu.com/forums/t/3424.aspx). He basically says create a site column of the type lookup field pointed to your lists. That way any site underneath can inherit these lookup fields. This is the most simple and brilliant thing I have done today, aside from creating a few search scopes. As usual Paul rocks.