I have a farming database. One of the tables contains the amount of chemicals a farmer has on hand. I have a form that lists the chemicals available to use on different fields. The form has a field that allows the farmer to enter the amount of chemicals used on each field. How would I use a calculated field to update the table and then show the farmer (on the same form) how much of each chemical he has left?
The farmer leases fields from different people and uses different chemicals depending on which field he's working and the crop he has planted.
Any help would be greatly appreciated. Thanks.
Martin
The farmer leases fields from different people and uses different chemicals depending on which field he's working and the crop he has planted.
Any help would be greatly appreciated. Thanks.
Martin