Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    37

    Exclamation Unanswered: Problem To Hard To Fit Plz Read

    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.

  2. #2
    Join Date
    Nov 2002
    Posts
    37
    I made a macro to run an insert sql statement....it works, it's just crappy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •