Matthew Posted February 5, 2018 Report Share Posted February 5, 2018 Hello, Is there a JS solution that'll allow me to create a multi-select dropdown on a submission form. I'm trying to create form where mentor can create a user account, but that account must be links to a studentID's on a separate table. Ideally we'd like it if the mentor could be be linked to multiple students at one time if needed. I'm aware of this article, but it doesn't apply to Submission Forms or droppowns specifically: Any help would be greatly appreciated! Kind Regards, Matt Quote Link to comment Share on other sites More sharing options...
MayMusic Posted February 7, 2018 Report Share Posted February 7, 2018 You cannot enable multi-select on dropdown only list box. List string cannot help either as the values needs to be static not from other table (Students). It is better to create a mentor_student table and save IDs in there. this is the correct way if doing it So you these tables: Mentor: Mentor_ID, Name, ... Student: Student_ID, Name , ... Mentor_Table: Mentor_ID, Student_ID, ... This way mentor can get access to full info of a student from Student table if required. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.