AndyC88
Member
- Local time
- Today, 03:36
- Joined
- Dec 4, 2020
- Messages
- 44
Afternoon all,
I have a table (TblEquipmentRequirements) with the following fields:
EquipmentRequirementID (PK)
EmployeeID (FK)
EquipmentID (FK)
Required (check box - YES /NO, not strictly necessary but required for UI/UX)
When I create a new record for a new employee, I'm trying to use an APPEND query to insert the list of available equipment (contained in TblEquipment) into the TblEquipmentRequirements - so staff can use the check boxes to select the required equipment.
Issue I'm having is I can't find a way to insert the new EmployeeID as well which is required - access returns the key validation error.
Any advice?
Thanks,
I have a table (TblEquipmentRequirements) with the following fields:
EquipmentRequirementID (PK)
EmployeeID (FK)
EquipmentID (FK)
Required (check box - YES /NO, not strictly necessary but required for UI/UX)
When I create a new record for a new employee, I'm trying to use an APPEND query to insert the list of available equipment (contained in TblEquipment) into the TblEquipmentRequirements - so staff can use the check boxes to select the required equipment.
Issue I'm having is I can't find a way to insert the new EmployeeID as well which is required - access returns the key validation error.
Any advice?
Thanks,