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
Subscribe to our Windows Secrets Newsletter - It's Free!
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!