Thanks Mark for the response,
I have tblPurchaseDetails, which contains the foreign key from tblEquipment, the foreign key from tblSupplies, and the foreign key from tblOffices. I then created a query from tblPurchaseDetails, which contain only numbers in the fields from tblEquipment...