Multiple Select ListBox help..??

[losingmymind]

I’m hoping someone can help with this…it’s gotta be possible. Anyway, here’s what I’m trying to do. I have a database of “Customers” with all their pertinent data to include employees who are associated to that particular customer. There are over 150 employees and thousands of customers. What I want to do is be able to select more than one employee to be associated to a particular customer. Sometimes there’s just one, other times there’s 10. I want to be able to query an employee and see who all of his customers are even if there’s more than one employee attached to the customer without having duplicate customers for each employee. Does that make sense? I have a table with all the customers listed. The last column is the “Employee” but I can’t get more than one in there. A list box with “auto populate” would be good so I don’t have to scroll through all the Employees, too. Can anyone help? Thanks so much :-)

[orange]

What you have have described is a classic 1 to many situation, and may be many to many.

One Customer is served by several Employees.

But can one employee serve several customers?

See the article at this link for more info
http://databases.about.com/od/specif...R-Diagrams.htm

[losingmymind]

What you have have described is a classic 1 to many situation, and may be many to many.

One Customer is served by several Employees.

But can one employee serve several customers?

See the article at this link for more info
http://databases.about.com/od/specif...R-Diagrams.htm

After reading everything from your link I have a better understanding of how it should work, however, I'm still a little confused as to how to create a foreign key. Maybe I can clarify my situation a little better....
Employee 1 is associated to Customer 1, 5, 10, 80, etc.....
Employee 2 is associated to Customer 1, 2, 10, etc....
Employee 3 is associated to Customer 2, 15, 50 etc....

I want to be able to Query Employee 1 and get Customers 1, 5, 10 etc to return or Query Customer 1 and get Employees 1 and 2 to return. Does that make sense? Also, some customers might be duplicated...for instance, Customer 1 might be encountered today and in three weeks from now that same customer will be encountered but with an entirely different situation so a new record needs to be created. Ultimately, if I were to query a customer I would be able to see all of his encounters...I might have confused you, sorry.

Thank you for your input :-)

[orange]

You have described a many to many

Employees (1 and 2) are associated with Customers (1 and 10).
Here is a free video tutorial on solving this.
https://www.youtube.com/watch?v=7XstSSyG8fw

Good luck

[burrina]

A screenshot of your form and or query would be helpful. A simple 2 table query with criteria should solve this! Also consider doing a Combobox and use a filter for it.