I’m trying to create a pop up form that creates a new record(the fields are Customer, PetName, Breed, PrimaryGroomer, DOB, etc). I have been told that using the Lookup feature of Access is not very good. I want the user to be able to choose the Breed field by using a combo box that lists all the Breeds in the system. What is the best way to accomplish this?
