Pointer in the right direction required
I'm assuming that Dynamic Dropdowns will be involved here, hence posting in this forum.
This is what I want to do. I'd be grateful of some pointers in the right direction.
The overall view is that members of a site can create a mailing list. (This I've done). I then want the member who has created the list to then be able to choose other members of the site to add to the list to be a recipient of the emails.
So The member creates the list (this is done) and then moves to the next page taking the listID with them.
Here, I'd like them to see a list of other members and to be able to pick them and add them to the listMembers table.
The table for the mailing list is:
mailingListID (Auto increment)
name (The name of the list)
The people table has
peopleID (auto increment)
the listMembers table has
listMembersID (auto increment)
MailingListID (this is the ID of the mailing list (Foreign Key))
peopleID (this is the ID of the member (Foreign Key))
So you arrive on the page with the mailingListID parameter, see list of other members from the People Table, pick the ones you want and have them added to the table listMembers. So it will add from one to 100 (or more) records to the listMembers table.
The layout of the tables is inherited from the previous site and already has data so it would be difficult to alter these tables.
The result in MySql would look like this
listMemberID MailingListID peopleID
1 88 23
2 88 56
3 88 78
and so on
I'm assuming that Dynamic Dropdowns would do this but as yet have been unable to actually get it to work :(
Then the plan is to use dataAssist to insert the records. But I also want to be able to edit the "listMembers" it just seems to get more and more complicated...
Could someone just give me some structure to work to.