Assuming the folling tables and field names
Table Name = "Lot"
Field 1 = LotNumber
Field 2 = Weight
Primary Key is Field 1 "LotNumber"
This table is populated with lot numbers and weights.
Table Name = "LotEntry"
Field 1 = LotNumber
Field 2 = Weight
This is a data entry table or form.
I am trying to have the "weight" field in the table "LotEntry" populate automatically once a lot number is entered in the lot entry table. I do not want a drop down box, just an automatic update of the weight field.
Please help
Table Name = "Lot"
Field 1 = LotNumber
Field 2 = Weight
Primary Key is Field 1 "LotNumber"
This table is populated with lot numbers and weights.
Table Name = "LotEntry"
Field 1 = LotNumber
Field 2 = Weight
This is a data entry table or form.
I am trying to have the "weight" field in the table "LotEntry" populate automatically once a lot number is entered in the lot entry table. I do not want a drop down box, just an automatic update of the weight field.
Please help