Using a value in one table as the default value for another table

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

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
 
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
 
Back
Top