| | |
|
|
|
Using a value in one table as the default value for another table |
|---|
| message from Mark on 6 May 2004 |
I am trying to setup a database to record production. I
want to set different work factors in one table that will
remain constant for the records but different based on
the site using the database. I was hoping to set the
values in one table and then in the main table use these
values as the default value for the field. I haven't had
any luck. Any suggestions.
Thanks
Mark
|
| Nikos Yannacopoulos replied to Mark on 7 May 2004 |
Mark,
I don't think there is a way to do this at table level, at leat I do not
know of one. It can be done in other object types, though. For instance, if
data entry to the main table is done through a form, then in your form
design you can use a DLookup function (on the lookup table you were thinking
of - correct approach) in the Default Value property of the control bound to
the field in question. If data is appended from a file or other table by
means of an Append query, you can use the same function in a calculated
field in the query design.
HTH,
Nikos
"Mark" <markwaltz@cox.net> wrote in message
news:92e201c4336a$696604a0$a501280a@phx.gbl...
|
|
Archived message: Using a value in one table as the default value for another table (MS Access Forms)
