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 > -- Tim Blankenship [EMAIL PROTECTED] ********************************************************************** 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 **********************************************************************
