Why You Should Avoid the Lookup Wizard and Lookup Fields in Tables in Microsoft Access

[@pmsteamrailroading]

I certainly agree that using the wizard to enter the values is a horrible idea. But if you have set up the lookup table, the wizard does a very good job of setting up a combo box and setting up the relationship. So, like many things, how you use it will determine whether it’s evil.

[@Shadow.Dragon]

Thanks for the informative video! I did not know you could "copy/paste" values into a table. I have always just typed them in... 😞 LOL!!!

[@xavierbatlle1828]

😂😂😂 so do I!

[@markfannin3975]

Pure gold! (yes, I'm a gold member, but if the shoe fits...). I don't skip around in your videos because you share great tips for using access. At minute 6:10 in this video you demonstrated how to copy from the expression builder into the new table column. Valuable tip for me at least. Thanks for another great video.

[@erlenditland3669]

I get the point about usuing them for value lists, but are they still "evil" if you set them up with a table reference?

[@donharrold1375]

Completely understand why you wouldn’t want lookup lists inside tables. However, I hear a degree of opposition against lookup functions using dedicated external tables too. Some people think it will corrupt the database. I don’t understand why? Can you explain if there are any risks with the better approach?

[@shanebuckham7029]

Would love an answer to this too!

[@easyspeak101]

Just in case you happen to read youtube videos .. Thank you Richard for all the worked examples, much appreciated.. I find details hard to remember.. even if I work material, , it's an age thing for me or something...lol 👍👍

[@RandalSullivan-n4b]

Another great video, informative as always thank you!

[@599CD]

You're very welcome

[@raphaelwanyoro9460]

Hello Richard. Can I send you a database project problem for you to break down and make a video tutorial.

[@shailendrasoliya]

Sir i have linked sql server with ms access in sql server table one field is varbinary (max) in which student photo are store but i am not able to upload photo on this field using ms access and not see photo on form and report Please make a video on this problem

[@Jgc81]

Use less