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.