Hi Steve, thanks for your time on this, and yes, this is what I have been trying to accomplish, structurally speaking. Since the Candidates table cannot populate more than one entry per field for a given candidate_ID , I concluded I needed a 3rd table where all the subscriptions would be logged, and retreivable through a repeater in the Candidate profile page .
Candidates can create an account (stored in the Candidates table) and modify their personal profile on the CandidateUpdateID page. Candidates can subscribe to applications on their own and this is logged in the Candidates table, in the field subscription .
I also have a hidden page called Candidates entry form , from where I populate the same Candidates table. This table has a lot more fields than the user (candidate) has access to. From this page, I can add potential candidates on my own in the Candidates table and suggest subscriptions for each, from a dropdown menu. This is the item (dropdown) that populates the Subscriptions table.
The Subscriptions table has 3 simple fields : CandidateUpdateID , subscription (from Candidates table) and suggestions , from the Candidates entry form dropdown.
In trying this, I was confronted to 2 problems:
1- I cannot submit the candidate’s info ( first name, name, email etc.) into Candidates table AND the dropdown data, Subscriptions at once;
2- I cannot find a way to use the candidates_ID in order to link the 3 tables together.
I hope I’m clearer this time ![]()
Thanks again