Multiple values to link to other tables

[Brennan]

I have a question about the structure of a query. I have a table with the
following information:

Name REVCriteria
Tom Customer1, Customer2, Customer3
Sally Customer 4, Customer7
Nick Customer 2



I would to create a query that links to another with table contains the REV
and GM numbers. The query output would look something like this:

Name REV
TOm Customer1
Tom Customer2
Tom Customer3
Sally Customer4
Sally Customer7
Nick Customer2

Basically, I want to know if there is a way to use multiple values in a
field to link to other tables? Any help is appreciated. Thanks

Brennan

 

[Klatuu]

No, and putting multiple values in a field is a very bad idea (as you can see)
You could use a table and load the data using recordset processing.

 

[Brennan]

What is recordset processing? Thanks for your reply.

Brennan