Thanks, that is closer to what i want, but do you know how for instance when you add a record, "John" is the default for the salesman field. The next time you add a record "Brenda" is the default and so on. These names need to be auto put in the field as the new record is being created. The...