Jeff,
You are there! What I've always done is have a table to store the image information, another to store the software title info, and a third to connect them.
I.E.
Image1ID SoftwareID
1 1
1 2
1 3
2 2
2 3
3 1
3 3

Make sense?

Kevin

dartcoach

This seems like it will work, and I am very excited!

Now I need to get this info. into my frmImages. How do I go about having them choose Software to link to the opened Image? Can I still use a list box?

Create a subform that links on the image id to the software Id. I usually use combo boxes to choose which software is on the image, instead of a listbox. It's much easier.

Make sense?

Kevin

dartcoach

Sorry if I'm being redundant, but what I'd really like is for someone to be able to open the Images form and see a list box, populated with Software names and be able to select the ones they want. Is this possible?

Yes. You have to populate the listbox from the software titles. Once they've chosen the titles they want, you must programmatically insert a record into your table for the relationship.

Kevin

dartcoach

I can populate the listbox without trouble, but how do I go about "programmatically [inserting] a record into [my] table for the relationship"???

Now we're kind of back at square one, although now it might actually work with the m-to-m relationship.

Jeff,
Once they've selected the items from your list box, do you have a button for "Update Image"?
If you do, you have to check for each selected item and run an sql statement to insert the record.
Have you used VBA? It would have to be there. Could you send me your database? I could play with it and send it back.

Kevin

dartcoach

I can easily create a command button for updating it. I have very limited knowledge of VBA, but can navigate someone else's code with a good amount of understanding. I'll send you it now.