Jumat, 03 Agustus 2012

[MS_AccessPros] Look up fixed value

 


I have a Projects table that includes a currency field 'Rate'. I need
each new entry to use the 'Rate' as recorded in a separate table
'tServiceRate'.

I have used this:

=[tServiceRate].[Rate]

as the default value for 'Rate' in the Projects. Error reports
"cannot find field".

What have I missed?

Many thanks,

Robin Chapple.

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar