Is there a way to pre-set a value for one field before importing records, such that this new value would populate that field for each new record.

I have a list of standard tasks in one table. I would like to be able to change the name of a particular WORKER on the fly, then import a list of tasks with his name entered into the WORKER field.

The list of tasks would be imported as a list of constants, but the name field would be variable, before the import.

I hope I explained this right.

Any ideas?

Jarvis

One way to do this is to create a global field in the Tasks table for the worker. Set or choose the worker, then import the global along with the regular task fields. It will be the same value for all imported records.

Thanks Fenton!

I hadn't considered changing the imported data with a global field. For some reason I was thinking this would come under an auto enter type function. I might also have been suffering coffee deficit at the time.

I will look into what you suggest.

Jarvis