What am I doing wrong?

[Benny Wong]

Hello All,
I am using Access 2000. I have created the tables, forms, and reports. However, the user needed a "Search Tool" to search and update the individual fields for the table. The tables involved are tblClient and tblContatType. I have set the relationships between the two tables and tblClient is the one and the tblContactType is the many. Currently, the database has data and what I did was:
1. Created a query that has the two tables linked. I ran the query and it showed all the data about 4,000 records.
2. I created a form that references this query and populate the form with the fieldlist from the query. I opened the form in edit mode and I noticed on the records shown for the form at the bottom is considerable less than what the query that I build earlier. I tried to search the individual fields and could not find all the records that I could find in the query builder.

What am I doing wrong?

Any help in resolving this is greatly appreciated. Thanks in advance.

 

[Rob.Mills]

Well, I'm taking a guess at a couple of things here. It sounds like your relationship is incorrect. The tblClient has a field in it to reference tblContactType (most likely the primary key of tblContactType, Yes?). In that case tbl Client should be on the 'Many' side.

Also, the records that are not showing up... Are they missing data in the field in tblClient that's part of the relationship? If so, they won't show up in the recordset.