1 Reply Latest reply on Jun 5, 2008 9:29 PM by Jim Barrows

    needing to have extra fields accessible in association table

    Pucky Loucks Newbie

      I have a system that I'm building that I need to store extra information within an association table. for example.

      many to many relationship between consultant and learner

      the association table should have
      [consultant_learner]
      id
      consultantid
      learnerid
      timestamp
      withdrawndate
      active



      is there a best practice for this? More or less I'm trying to get my head around having logic within that intersection table.

      Anyone have link they can provide? Is this possible?

      Thanks,
      Pucky