Linking Lookup Tables

Hi,
If you have lookup tables which are used by multiple tables (e.g.
'City' lookup table might be used by the 'Employee' and the 'Company'
tables) do we need to link it to both tables? Or can it sit by itself
and just referenced?

Cheers,
JackAlthough there is no requirement to do so, one usually creates foreign key
constraints in order to enforce referential integrity. This ensures
Employee or Company City is valid when rows are inserted and updated.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Jack" <jack-b@.humlog.com> wrote in message
news:6ea814a3.0411221906.33f4fc57@.posting.google.c om...
> Hi,
> If you have lookup tables which are used by multiple tables (e.g.
> 'City' lookup table might be used by the 'Employee' and the 'Company'
> tables) do we need to link it to both tables? Or can it sit by itself
> and just referenced?
> Cheers,
> Jack|||Great - thanks for that.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!sql