Inefficient way to update table

[wcrc]

I want to scream over this one, but please bear with me.

I have a field in form that concatenates 2 fields from a table, the powers that be, want to store this calculated value as a joined field with another table. (bang head here)

I presently use a make table query to concatenate the field and rewrite the table over the original every night.

Can I automate this? How?

Sorry, but I inherited this Db from someone else and now there is an established "Way we do things" so copletely restructuring the data is not an option.

 

[Jack Cowley]

I will not go on a rant about the 'superior intellect of the powers that be"... ARGHHH.. You will find a scheduling program here and you will find an article or two in the MS KB.

hth,
Jack