I have 3 tables: tblGeneralInfo, tblCap_Airflow, and tblCap_Yes/NoQuestions and a form with 2 buttons: Airflow and DER Repairs.
Here are the relationships:
The Airflow column from the tblCap_Airflow is a multi-valued field where a Company can have many Airflow capabilities which allows the "Company Name" column to have repeated company names
I'm looking to create a form using tblCap_Airflow that is able to return all Company Names and their corresponding Details (if available) with respect to the selected Airflow value and when the "Airflow" button is clicked, the form is prompted.
Selected Airflow Value = CCDI massflow machine
Number of Companies = 4
List of Company Names:
The "Performing DER Repairs" column from tblCap_Yes/NoQuestions is also a multi-valued field with returns only Yes or No, therefore, the company names in the "Company Name" column only occur once
For this table, I'm looking to do the same things as mentioned above, however, only count and return company names that have "Yes" in the "Performing DER Repairs" column.
I tried to create a combo box for Airflow to select Airflow option but it doesn't seem to work. The drop down list contains repeated values, not unique ones and it either only returns one company name at a time (not all companies) OR doesn't return anything at all.
I don't have any experience with Access and this is my first time dealing with it. Please can anyone show me how to go about this? Thank you so much!