lookup table/relationship

[OCM]

Greetings,
I have created a database to track applicants eligibility process. Just recently, I was approached to add a new field to find out how applicants know about our program (through Friend, Family, School, other etc.)
So I created a lookup table and added a new field 'AppSource' to an existing table (tblHouseHold), and created relationships (please see attached screenshot).
1. On my form I do not see the dropdowns.
2. How should the query look like so I can get a total # for each AppSources. For example 80 applicants learn about our program throug Friend, 50 applicants learn about our program thrugh School etc.




Thanks,


OCM

 

[dhookom]

Consider reading this about lookup fields

http://www.mvps.org/access/lookupfields.htm.

Add a combo box on the form that is bound to AppSource and has a row source of the lookup table.

You can add the lookup table to your query and group by the description field and count the records.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.