Default values

[Guest]

Table 1: A list of employees their Identification numbers and Hourly wage rate.
Table 2: A list of where they have worked linked to their ID, but the rate
has to default to the rate as in Table 1, but might change depending on the
supervisor's feeling.

Now! In the form I call Input, I need to view the rate as it is in Table 1,
but need to change it as described above and save it in Table 2.

 

[Al Campagna]

On your Input form, use the AfterUpdate event of your EmployeeID field to trigger a
Dlookup against table1 as the default WageRate on any new record, and then change it if
necessary.
On a new record, a Default value of something like a Dlookup of that person's Wage Rate
can not be determined because no ID has been entered yet... and after it has been
enetered, it's too late for a the Default value.
So, use the EmployeeID entry to trigger that value.