This is my problem:

I have a many to many between two tables, software and users.
When I make a new record in the sofware table, I need to associate every person in the user table with that peice of software, which would be done in the detail/joining table.
I basically need to assign ever user-key to that software-key when I make a new record.
If I delete the software at a later time will it update the detail automatically so that it doesnt have a delted Software-key?

This is hard but I hope someone out there has run in to this problem.

I made a macro to run an insert sql statement....it works, it's just crappy.