Search for common items and relevant records

%3CLINGO-SUB%20id%3D%22lingo-sub-462390%22%20slang%3D%22en-US%22%3ESearch%20for%20common%20items%20and%20relevant%20records%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-462390%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fliveconcordia-my.sharepoint.com%2F%3Au%3A%2Fg%2Fpersonal%2Ft_oa_live_concordia_ca%2FEbggaNVwO2tJnJPku0Lf7QkBC8m72UPruEV7atyrnaHuKg%3Fe%3DdQVv3o%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHere%20is%20the%20link%20to%20my%20sample%20Access%20file%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EQuestion%201%3A%3C%2FSTRONG%3E%20Using%20tblCap_Welding%2C%20tblCap_NDT%2C%20and%20tblCap_Yes%2FNoQuestions%2C%20is%20there%20a%20way%20to%20create%20a%20form%20where%20I%20can%20see%20all%20information%20related%20to%20a%20Supplier%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20A%20is%20selected%20from%20the%20combo%20box%20(using%20Supplier%20Name%20from%20tblGeneralInfo)%2C%20the%20form%20will%20show%20everything%20A%20has%20from%20the%203%20tables%20I%20just%20mentioned.%3C%2FP%3E%3CP%3EWelding%3A%20TIG%2C%20Laser%2C%20Resitance%20Spot%20%26amp%3B%20Stitch%20Welder%3C%2FP%3E%3CP%3ENDT%3A%20Radiographic%3C%2FP%3E%3CP%3EDER%20Repairs%3A%20No%3C%2FP%3E%3CP%3EDER%20Repairs%20Detail%3A%3C%2FP%3E%3CP%3EBalancing%3A%20Yes%3C%2FP%3E%3CP%3ETooling%20Design%3A%20Yes%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuestion%202%3A%20I%20tried%20to%20create%20a%20form%20with%20a%20combo%20box%20from%20the%20%22Welding%22%20column%20to%20search%20for%20Suppliers%20that're%20capable%20of%20doing%20those%20Welding%20capabilities.%20However%2C%20when%20I%20set%20the%20combo%20box%20to%20%22I%20want%20the%20combo%20box%20to%20get%20the%20values%20from%20another%20tables%20or%20query%22%2C%20it%20didn't%20seem%20to%20work%20the%20way%20I%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20tblCap_Welding%2C%20my%20Welding%20column%20has%20repeating%20records%20(for%20example%2C%20multiple%20Suppliers%20have%20TIG).%20So%20when%20I%20set%20it%20up%20in%20the%20combo%20box%2C%20there%20were%20several%20TIG%20values.%20How%20can%20I%20set%20my%20combo%20box%20to%20Unique%20values%20only%20and%20get%20it%20to%20search%20for%20Suppliers%20that%20can%20do%20a%20certain%20Welding%20Capability%20(chosen%20from%20the%20combo%20box)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EQuestion%203%3A%3C%2FSTRONG%3E%20In%20the%20frmContactDetails%2C%20can%20you%20please%20show%20me%20how%20I%20can%20get%20the%20combo%20box%20to%20search%20for%20all%20contact%20details%20of%20the%20selected%20supplier%3F%20I%20was%20trying%20to%20set%20the%20form%20to%20Continuous%20Form%20to%20make%20it%20show%20all%20contact%20details%20but%20then%20both%20my%20%22Select%20a%20supplier%22%20combo%20box%20didn't%20work%20and%20the%20form%20show%20all%20info%20of%20all%20suppliers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!!!%20Thank%20you%20so%20much%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-462390%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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