Exactly, Grant.
The general rule of thumb that you want to follow is: if columns in two different tables hold the same values and are intended to match each other then you should give them the same name. This makes life so much easier later on.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]