G
grizzes
Guest
I am trying to automatically bring in the last values of each field of a record into the fields of a new record to minimize typing for my sales guys.
Specifically, a form must be created every time a test is run on a piece of equipment. Generally the fields will not change for a piece of equipment, but they sometimes will.
The equipment and information that does not change is set in one table. The fields which can change per analysis is set in a separate table which is linked to the equipment table.
I can get it to find the last record per piece of equipment but I can't figure out how to get the new record to read the last record - so that I can populate the new fields with the old fields' values.
I would appreciate any ideas.
Specifically, a form must be created every time a test is run on a piece of equipment. Generally the fields will not change for a piece of equipment, but they sometimes will.
The equipment and information that does not change is set in one table. The fields which can change per analysis is set in a separate table which is linked to the equipment table.
I can get it to find the last record per piece of equipment but I can't figure out how to get the new record to read the last record - so that I can populate the new fields with the old fields' values.
I would appreciate any ideas.