Hi Jeff, You're right; the relationship is the same as between the PlumUser and PlumUserRole tables. However, this is not an admin function. What I have are students who need to select what class they are taking on the InformationalData form and then populate that junction table. The Display chooser control could work in the InformationalData form but as you can see I had to separate that data out from the PlumUser table because not all users are students.
Dan -----Original Message----- From: Jeff Fleitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 01, 2005 10:36 AM To: [email protected] Subject: Re: [plum] Filtered Selects Hi Dan, I think what you want is to add another DisplayChooser control in you PlumUserAdd/Edit forms. The relationship is the same as between the PlumUser and PlumUserRole tables, if I read you right. Just open the PlumUserEditForm and make a copy of the control there at the bottom of the page and change the variables to match the Classes table. Jeff Nall Daniel A GS-09 336 TRSS/TSUD wrote: > I have a form that populates the InformationalData table. Within that > form is a filtered select from the Classes table. I want to also > populate a many-to-many join table (UserClassJunction) with the UserID > from the logged in user (I have that as a session variable) and the > ClassID from the Classes table. Hope that makes sense. I included a > diagram of the relationship in the original e-mail. Did it get through? > > Respectfully, > Dan Nall > > -----Original Message----- > From: Tim Blankenship [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 01, 2005 10:16 AM > To: [email protected] > Subject: Re: [plum] Filtered Selects > > I am a little confused (which is normal) tell me if i am interpreting > this correctly. > You have a form that you want to populate the InformationData table? > > > On Tue, 1 Mar 2005 11:56:56 -0600, Nall Daniel A GS-09 336 TRSS/TSUD > <[EMAIL PROTECTED]> wrote: > >> >> >> >> >> >>Good Morning Everyone, >> >> I have the following relationship in my database. I have a Filtered >>Select of ClassNumber from the Classes table displayed in the >>InformationalData table form. That works well but I'm confused as to > > how to > >>insert UserID ( I have UserID as a session variable - thanks Jeff) and >>ClassID into the many-to-many junction table UserClassJunction when >>InformationalData form is submitted. Again, I greatly appreciate all > > the > >>help you have all given me. >> >> >> >>Respectfully, >> >>Dan Nall >> > > > ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
