Coldbox [3.8] Link Table containing extra column

Hi All,
Does any know how to configure the entity when you have a link table that contains extra columns

Eg
Table A AId
Table B BId
Table A_B AId, BId, location

So, I created the many-many property, but the column location is not accessabile.

Does anyone know how to access it?

You can’t.

Many to many associations are plain and simple using just the two foreign keys. If you want to give identify to the join table. Then you must detach and create it as a one to many association on both sides as needed.

Luis Majano
CEO
Ortus Solutions, Corp
www.ortussolutions.com
P/F: 1-888-557-8057