I have two tables, one for equipment information, (EquipmentInformation) one for tests on the equipment, (EquipmentTest)
the equipment in formation table has a foreign key, (EquipmentID), which is the primary key in the equipment tests table. this allows me to assign test data to each piece of equipment.
the EquipmentInformation form is linked to the EquipmentTest form via a command button.
is it possible, after filling out or viewing the information on a piece of equipment in the EquipmentInformation form, to then press the command button to open the EquipmentTest form AND import the EquipmentID value from EquipmentInformation into the EquipmentID field in the EquipmentTest form.