Multiple values to link to other tables

  • Thread starter Thread starter Brennan
  • Start date Start date
B

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
 
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.
 
Back
Top