Now, I start my Access journey… but I am really confused with some concepts as a beginner.. eg:
What is the different between lookup and relationship?
As I understood, the lookup function are more or less like the “data validation” function in excel, of course, the validation source can be updated and synched together with other lookup source table. It seems that when I defined the lookup, the relationship is also built.. but I delete the relationship later, and it seems that the lookup connection is still working well.
Then what does the relationship mean? Isn’t lookup and relationship the same thing?
Also, when I defined the lookup in my first database, I defined a lookup connected with multiple items from another table, and in the drop down list, I am able to see all of them, but when I select it, it only shows the primary value in the cell.. is that suppose like that?
Could anyone here explain this for me?
Thanks.
What is the different between lookup and relationship?
As I understood, the lookup function are more or less like the “data validation” function in excel, of course, the validation source can be updated and synched together with other lookup source table. It seems that when I defined the lookup, the relationship is also built.. but I delete the relationship later, and it seems that the lookup connection is still working well.
Then what does the relationship mean? Isn’t lookup and relationship the same thing?
Also, when I defined the lookup in my first database, I defined a lookup connected with multiple items from another table, and in the drop down list, I am able to see all of them, but when I select it, it only shows the primary value in the cell.. is that suppose like that?
Could anyone here explain this for me?
Thanks.