2014-08-16, 14:42 #1
- Join Date
- Nov 2002
- London, Gtr London, England
- Thanked 0 Times in 0 Posts
Access 2013: What is a Lookup based on
If I am developing an asp db. I will use a Lookup based on a reference table, my question is how is this implemented? If I have a regular relational db then the lookup is based on a foreign key to the reference data table, I would use a numeric ID field and them retrieve the text value from the reference table for display purposes. However Access 2013 the db offered lookup as a data type and on selecting the table I can select the field to display. If I choose the 'name' field in the table what is stored in the table with the Lookup field? The reason I need to know is to understand what happens if, for example, the 'name' of an existing record in the reference table changes - will it also change on related records?
Thank you....................... liz
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!