To make this easier to understand.
I have two tables
Table 1 Table 2
Member (is a number) Member(is a number)
Case (is a number)

A Member may have more than one Case. The Member number is unique while the Member may have many Cases.

I want to create another table from these two called Table 3
In this table I want (in one record, two fields) the Member and all that members cases.

Table 3
Member (one name)
Case(may have more than one number)
The result might look something like this
Member Case
1234 11111,33333,56565,6767

Can somone tell me how to do this?

One way

http://www.mvps.org/access/modules/mdl0004.htm

I saw that but still didn't know what or how to do it. I just don't understand the steps I need to take