I have asked this same thing in the past. And I mentioned a textbox next to the dropdown that you or user could enter a search string to narrow down the search so all records aren't in the dropdown. I wish I knew how to program something like this myself. I believe any database should have this. Look at Alpha5, ms access, visual foxpro, and dbase, you can do this type of thing in all of them. I know it's harder on the web, but there's got to be a way. Futhermore, an overwrite needs to be there to. For example, if auto filling fields for a customer with shipping address, you also need to be able to override these fields if one particular time the ship address is different. Any of you that has used a desktop database should know what I'm referring to. Thanks. I'm still trying to figure out how to do this using php an mysql.