Jon Stolz
03-18-2002, 06:33 PM
I want to select a range of records in a Table named Tree. Tree Table Primary Key is TreeID Another field in the Tree Table is TreeLocation which is a field that identifies the tree. I have a subform called MaintHistory which is based on a Table named MaintHistory with following fields: LastMaintDate MaintPerformed LaborHours LaborWage MaterialsUsed MaterialsCost Primary Key MaintHistID foreign key is TreeID After selecting a range of multiple trees, I would like to key in the MaintHistory information only once because most times the same maintenace will be routinely done equally for many of the trees on the same day I would like to do this using a form with a TreeLocation range. Any suggestions would be deeply appreciated, would save us much data entry time!