needing to have extra fields accessible in association table

[pucky]

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

[jim.barrows]

Easily done., you just need a class in between:
Consultant [1] ->[N]ServiceInformation[N]<-Learner