• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Working with Database Data > Looking Up Information in a Data List

Looking Up Information in a Data List

Whenever you create a worksheet that holds information about a list of distinct items, such as products offered for sale by a company, you should ensure that at least one column in the list contains a unique value that distinguishes that row (and the item the row represents) from every other row in the list. Assigning each row a column with a unique value means that you can associate data in one worksheet with data in another worksheet. For example, if every customer is assigned a unique identification number, you can store a customer’s contact information in one worksheet and all of that customer’s orders in another worksheet, and be able to associate the customer’s orders and contact information without writing the contact information in a worksheet every time the customer places an order.


In the case of products sold by The Garden Company, the column with those unique values, or primary key column, is the Product ID column.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint