I have an office field in a memo database in which employees can select from which office they're sending the memo. It is set to auto enter our main office because many employees forget to selct the office field. My problem is that when a memo is duplicated the auto enter data overrides the office selected in the original record. Is there any way to keep the auto enter data active but stop it from overwriting data when a record is duplicated?

Thanks

[ May 22, 2001: Message edited by: Tombstone ]

Perhaps rather than using auto enter, you could add a set field line to your create new memo script. This way all fields contents will remain at duplication.

Example:

New Record Request

Set Field ["Location","Main Office"]

thanks MarkPro,

Works well just hope nobody click on new record manually in the menus, and then forgets to click on their office.

You can prevent users from using the menu to create new records by using passwords and privileges. This way you won't have to worry about someone creating a new record without your script.

Chuck