I dunno either Jeff - :) I had thought to separate the tables out because there is such a large amount of information a student, but not any other user, has to fill out. InformationlData is just one of many forms. Perhaps it's back to the drawing board time but I am loathe to do this as I have come so far with this project.
Respectfully, Dan -----Original Message----- From: Jeff Fleitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 01, 2005 11:13 AM To: [email protected] Subject: Re: [plum] Filtered Selects I dunno. This would be so simple if you just added the fields in the Students table to the PlumUser table and made student and user synonymous. They really are, and going back over the earlier message thread regarding our earlier conversation, I still don't get why you didn't do this. Remember that you don't have to give the students access to the admin site. You can create a student module in the public side (outside of admin) and make fresh student forms using the PlumUser table with the added fields (omitting the admin stuff you don't want them to have access to). Create a STUDENT role, and use it to tie off the student module on the public side, so the general public can't get in there. Then you can create a whole slew of forms for the student and you don't have to jump through all those hoops to get what you want. You can still create all kinds of child relationships off of the PlumUser table. Now handling the UserID issue is moot. Maybe I am missing something critical here, but that makes more sense to me. What am I missing? Jeff Nall Daniel A GS-09 336 TRSS/TSUD wrote: > 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 > ********************************************************************** > > ********************************************************************** 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 **********************************************************************
