TechHelp

Lookup Wizard Upload Images Link
Adrienne Girard
6 months ago

I recently heard in one of your videos, "don't use lookup wizard" or something similar to that. I realized after I heard you that I had used them in several of my tables. How can I fix that and create combo boxes as you suggested in forms instead? I thought by going in and adding the foreign key and updating it on each table then create a form. The problem I find is that I already have data in this database, a good amount of data and I don't want to lose it so I am trying to be careful how I proceed to fix it. Your suggestions would be much appreciated.

Kevin Robertson
6 months ago

Check out these videos.

Multivalued Fields
Normalizing Data

Scott Axton
6 months ago

Richard explains a bit more about the "why" in the Relational Combo video. That will also explain how to set up a lookup outside of the tables.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to TechHelp Comments

Subscribe to TechHelp
Get notifications when this page is updated