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.