Relationship Issue

[Peter Kilcoyne]

Hi Folks:

I have a database "MarComProjects" and another "Parts". Table_Mail is  
in the "MarComProjects" db and Table_Parts is in the "Parts" db.

The relationship is Table_Parts  to Table_Mail via fields ProjNum in  
Table_Parts equal to ProjNum_job in Table_Mail AND Mail in  
Table_Parts equal to Mail_job in Table_Mail. Mail_job is a auto text  
field entered text field with the word "No".  Mail is a drop down  
list with the option of "yes" or "no". I have a portal in the  
"MarComProjects" that is set to view records from Table_Mail.

What I want is to view only the records of a set of projects that  
will mail, not all of the projects with the same ProjNum will mail.  
When I set this up I get the first project associated with ProjNum  
repeated 9 times in the Portal instead of the list of individual  
projects that make of the mail portion of the job.

I hope this makes sense and I hope you can point me in the righ  
direction.

TIA,
Peter