Search for common items and relevant records

New Contributor

Hello everyone,

 

Here is the link to my sample Access file

 

Question 1: Using tblCap_Welding, tblCap_NDT, and tblCap_Yes/NoQuestions, is there a way to create a form where I can see all information related to a Supplier?

 

For example, if A is selected from the combo box (using Supplier Name from tblGeneralInfo), the form will show everything A has from the 3 tables I just mentioned.

Welding: TIG, Laser, Resitance Spot & Stitch Welder

NDT: Radiographic

DER Repairs: No

DER Repairs Detail:

Balancing: Yes

Tooling Design: Yes

 

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

 

Please help!!! Thank you so much

 

0 Replies