Default value of the field

[ljubo lecic via AccessMonster.com]

Is it possible to define the default value for the field
in the table design to be the value of the field from another table.
(Dynamicaly defined default value)
I tried to write the subquery in the expression builder
but have some syntax errors.
Whereas I am not very familiar with the expression builder I need help.
Thanks in advance!

 

[Duane Hookom]

You can't do this in a table design. You can do this in a form.

 

[John Vinson]

Is it possible to define the default value for the field
in the table design to be the value of the field from another table.

No. This violates relational principles and is therefore not
available.

You can set the Default property of a control in a Form (the form you
should be using to enter data into your table) to a DLookUp()
expression retrieving a value from a table, but you can't do it in the
table properties.

John W. Vinson[MVP]

 

[ljubo lecic via AccessMonster.com]

Thank you very much!