Interracting with Association Collections in blocks and forms

[ElMehdiBen]

I have been getting deep inside of Nocobase with a use case I’m working on lately and it raised few questions in my head that I’m sharing with you below.

1. Is there a way to interact with association collections (for many to many case) ? Meaning, can I add fields that I have on an association collection to a form ?
2. I didn’t find any way to show a block from an association field that is needed to be shown. I want to make it proper on the use case and not just solve it with a workaround.

Attached are two screenshots explaining a bit of what I need. It’s easy to add a field into the association table “Team_Members” but I didn’t find how to populate the field using a form, or show the table in a table block on a page…

Thanks a lot

[support]

Hi @ElMehdiBen Do you mean that you want to add the block of the intermediate table to the page?

[ElMehdiBen]

Yes exactly, I have a better example :
Candidate Table and Exam Table, it’s a many to many relationship as multiples candidate can have multiple exams meaning that the intermediate table should have Candidate_ID, Exam_ID and Grade. I need a way to have a form block so I can input the Grade for a candidate in a specific exam.

Thanks,

[support]

Create 3 collections named Candidate, Exam, Grade. Create a many-to-many field in Candidate and select Grade as Through collection.