Often we reference to a second table where we either select an existing record or we need to create a new record. It would be amazing if we could search existing records by typing. If the record doesnt exist allow new record creation without having to leave the form and go to the referenced table.