Linking Lookup Tables - Microsoft SQL Server

Jack

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

Jul 20 '05 #1

Subscribe Reply

1415

Dan Guzman

Although 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" <ja****@humlog.com> wrote in message
news:6e**************************@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

Jul 20 '05 #2

Jack B

Great - thanks for that.

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

Jul 20 '05 #3

Similar topics

5597

Lookup Tables

by: CoreyWhite | last post by:

The future of computer architecture will use lookup tables. Currently computer processor speed outweighs the benefits of using computer memory for lookup tables, except in some cases. As computer...

C / C++

7009

Good practice for lookup tables?

by: Koen | last post by:

Hi all, My application uses a lot of lookup tables. I've splitted the frontend (forms, reports, etc) from the backend (data). The database has around 10 different users. The values in the...

Microsoft Access / VBA

2210

linking to a password protected database

by: gasturbtec | last post by:

please help im new at access programming and i just got this project dropped in my lap because the old programmer quit. i've been doing ok so far but now i need to add code to an existing database...

Microsoft Access / VBA

2902

lookup questions

by: my-wings | last post by:

I've been reading about how evil Lookup fields in tables are, but I've got to be missing something really basic. I know this subject has been covered before, because I've just spent an hour or two...

Microsoft Access / VBA

10600

Need an alternative to Lookup fields

by: google | last post by:

I have a database with four table. In one of the tables, I use about five lookup fields to get populate their dropdown list. I have read that lookup fields are really bad and may cause problems...

Microsoft Access / VBA

4501

Linking multiple tables alternatives

by: dskillingstad | last post by:

I've been struggling with this problem for some time and have tried multiple solutions with no luck. Let me start with, I'm a novice at Access and I'm not looking for someones help to design my...

Microsoft Access / VBA

3784

lookup tables

by: junky_fellow | last post by:

what are lookup tables ? How can they be used to optimise the code ?

C / C++

2261

How to update datagrid when it displays lookup table values

by: dbuchanan | last post by:

Hello, (Windows forms - SQL Server) I fill my datagrid with a stored procedure that includes relationships to lookup tables so that users can see the values of the combobox selections rather...

Visual Basic .NET

12711

linking tables from other databases?

by: misscrf | last post by:

In a database, I am creating a new db. From there, I am setting up the tables, so that I can eventually create a front end (usually access, but I may attempt to be brave and lose the shell.) ...

Microsoft SQL Server

7039

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7037

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7080

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

5326

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4770

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

2992

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

2977

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

558

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

176

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General