C
Capt'n
Hi,
I am using Access 2000. I have two table: Assets and Maintenance
Relationship in one to many from the asset table to the maintenace
table. The maintenance table is Index by AssetID asc and MaintDate
Desc.
I need to show the latest maintenace date for each asset as the user
scrolls through the rows.
The maintenance form is a subform of the Asset form.
My question is how to I code the LastMaintDate field to get the latest
date from the Maintenance table for this asset?
Thanks,
Capt'n
I am using Access 2000. I have two table: Assets and Maintenance
Relationship in one to many from the asset table to the maintenace
table. The maintenance table is Index by AssetID asc and MaintDate
Desc.
I need to show the latest maintenace date for each asset as the user
scrolls through the rows.
The maintenance form is a subform of the Asset form.
My question is how to I code the LastMaintDate field to get the latest
date from the Maintenance table for this asset?
Thanks,
Capt'n