Hello! This is my first post here, so bear with me please. Here is my situation...

I'm creating a database with three main tables; Agency, SRD, and RSS (where SRD and RSS are high- and low-level system requirements, respectively). There exists a many-to-many relationship between each of these tables; Agency to SRD, Agency to RSS (with the primary key from SRD being part of the key in this table), and SRD to RSS. What I'd like to be able to do is allow the user to assign an as yet unassigned SRD (or RSS) to an Agency. I would like to use side-by-side listboxes to allow the user to create new associations between items. The listbox on the left would show all currently related SRDs (RSSs) to an agency, and the listbox on the right would show all unpicked items. Moving an item from right to left would create the association in the junction table, thus "assigning" that requirement to the Agency. I hope that made sense.

I would appreciate any thoughts you might have here. Thanks in advance!

- Keith

Well, I can sort of help, I guess. I have attached a ListBoxToListBox example.

Welcome to Utter Access Forums!

In addition to Frank's example, check out the following posts from the code archive:

- Using Listboxes in a Many to Many Relationship
- Using Check Boxes in a many to many relationship

HTH