A97: Filtering one table for similar records in another table

[RonMcIntire]

All:

I have a table of chapter members and a table of district members both containing similar member numbers.

I wish to filter the district table for the member numbers in the chapter table. Result would be a list of member numbers contained in the chapter table.

Is it possible? If so, how would I go about it?

Thanks,

Ron

 

[PHV]

Simply JOIN the district table to the chapter table on the member fields.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RonMcIntire]

PHV:

Thanks for your help. How simple! I should have thought of that.

Ron