var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Field Design
Is it possible to have 2 field in a table,
and 1 is always equal to the other.
Equal at insert and update.
(This because, I want to have a duplicate field for a renaming and
future abandon of the 1st one, new developpement will use the new field)
Thanks for any help.
Hmmm...well you could try this:
Place a statement something like what is shown below into the 'Before Update' event of your data entry form:
Me.Field10 = Me.Field1
As records are entered Field10 will always be the same as Field1.
No, I am not programming in Access language,
and I do not want to do this by programming,
I was just wondering if inside the Access DB design, we could affect
a value to a field which will always be the value of an other field,
at insert and modify actions.
Thanks for your help.
Nope. Like CyberLynx stated it will have to be done thru code of some kind (VBA or Query) ...