Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Lookup table definition
- Thread starter shyamal
- Start date
A lookup table contains information for valid values for another tables fields.
For example.
you have a product table which contains all your products and prices.
and
you have a sales details table which contains items should for a particular order.
the sales details may have a "product" field which uses the product table (which also has a "product" field) as a look up.
You can set this link so that SQl server can validate inputs from users and only allow values which appear in the lookup table.
I am not good at explaining but i hope this helps.
For example.
you have a product table which contains all your products and prices.
and
you have a sales details table which contains items should for a particular order.
the sales details may have a "product" field which uses the product table (which also has a "product" field) as a look up.
You can set this link so that SQl server can validate inputs from users and only allow values which appear in the lookup table.
I am not good at explaining but i hope this helps.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question