Apr 09 2019 10:29 AM
Hi everyone,
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:
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.
Desired result:
Selected Airflow Value = CCDI massflow machine
Number of Companies = 4
List of Company Names:
1. A
2. CHR
3. ETH
4. REV
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!
Apr 13 2019 02:07 AM
May 07 2019 05:00 PM