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
**********************************************************************
