Default value of the field

  • Thread starter Thread starter ljubo lecic via AccessMonster.com
  • Start date Start date
L

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!
 
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.
Click to expand...

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]
 
John said:
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.
Click to expand...

A front end application should not relied upon in place of constraints
in the database layer to maintain data integrity. A CHECK constraint to
reference other tables could be included in the table definition.

Jamie.

--
 
Back
Top