Query Trouble

[nancybrown]

I am trying to create a very simple query using two tables and am not having any luck.

tblCity: 1) pkCityID; 2) City.
tblContribution: 1) pkContribution; fkCityID; Payee; City (other fields that aren't relative to this problem)

tblContribution data is popoulated using a data entry form.

My relationship is tblCity/pkCityID one to many to tblContribution/fkCityID, and the Join Type is set to match everything from both tables.

All cities that are in tblCity are also in tblContribution, nothing returns when I run the query.

Can someone advise . . . never had this happen before.

 

[nancybrown]

I'm glad you gave a description of how to use the cbo in a form . . . this is how I've been doing it so now I know I've done that part correctly. I only mentioned the cbo and form to give details as to how I plan to use the tables. Usually I get scolded for not giving enough information . . . so this time I gave more then I should have.