If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Default value of the field
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! -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
You can't do this in a table design. You can do this in a form.
-- Duane Hookom MS Access MVP -- "ljubo lecic via AccessMonster.com" wrote in message news:524b6f1966574d09b3eb32239c060ee7@AccessMonste r.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! -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
On Mon, 14 Mar 2005 19:58:10 GMT, "ljubo lecic via AccessMonster.com"
wrote: 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] |
#4
|
|||
|
|||
|
#5
|
|||
|
|||
John Vinson wrote: 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. 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. -- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
DCount compare table.textfield to form.text field question | RNUSZ@OKDPS | Using Forms | 1 | March 11th, 2005 03:05 AM |
Setting default value in textbox field on form | Christian | Using Forms | 5 | January 16th, 2005 08:13 AM |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 06:15 PM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |
Contact Default Field View | dmahanay | Contacts | 0 | May 22nd, 2004 12:47 PM |