Multiple values to link to other tables

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
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top