Question 2: I tried to create a form with a combo box from the "Welding" column to search for Suppliers that're capable of doing those Welding capabilities. However, when I set the combo box to "I want the combo box to get the values from another tables or query", it didn't seem to work the way I want.
In the tblCap_Welding, my Welding column has repeating records (for example, multiple Suppliers have TIG). So when I set it up in the combo box, there were several TIG values. How can I set my combo box to Unique values only and get it to search for Suppliers that can do a certain Welding Capability (chosen from the combo box)?
Question 3: In the frmContactDetails, can you please show me how I can get the combo box to search for all contact details of the selected supplier? I was trying to set the form to Continuous Form to make it show all contact details but then both my "Select a supplier" combo box didn't work and the form show all info of all suppliers