I have a table ‘tblConnections’ that records connections between two equipment items and includes fields called ‘EquipA_ID’ and ‘EquipB_ID’. I have another table called ‘tblEquipment’ that is used to record the descriptions of equipment against equipment IDs.
I have created a form which includes comboboxes for ‘EquipA_ID’ and ‘EquipB_ID’ and I have also added two other text boxes that I would like to display the equipment descriptions for the respective IDs referencing the single ‘tblEquipment’ table.
How do I achieve this?