If there are more offices than can appear in the filtered select at one time, the filter will always show. Also, if this is the case, the form by default will only show the one record related to the record currently being displayed. This is expected behavior.
HTH, Dave ----- Original Message ----- From: "Jeff Fleitz" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, January 05, 2005 10:12 AM Subject: Re: [plum] Pre-flitering Filtered Select Menus > I will bring this up again, since it was ignored the first time ;) > > I am drilling down using master detail formsets: > > Company -> Office -> OfficeEmail > > The OfficeEmailEditForm is accessed from an embedded list in the > OfficeEditForm. I am trying to filter the DisplayFilteredSelect tag > which uses the Office.OfficeID foreign key, so that it displays only the > offices for the company drilled down from, by using the > whereClauseExtension attribute: > > <cf_DisplayFilteredSelect parentTable="Office" primaryKey="OfficeID" > primaryKeyType="integer" foreignKey="OfficeID" > displayColumn="OfficeName" displayColumnType="varchar(50)" > label="Office" required="Yes" whereclauseextension="CompanyID = > #Evaluate('#Application.persistentScope#.CompanyID')#"> > > Here is what the query result looks like from the debug stream: > > > queryResult (Datasource=maritrak, Time=0ms, Records=1) in > C:\CFusionMX7\wwwroot\maritrak\components\DatabaseBlocks.cfc @ 10:01:15.015 > > SELECT Office.OfficeID, Office.OfficeName > FROM Office > WHERE Office.OfficeID = 662 AND CompanyID = 642 > ORDER BY Office.OfficeName > > > I can't figure out why this query should have the OfficeID referenced in > the query? My filtered select menu should also not display the filter > text field, since it is only returning one record, but it does. > > Am I doing something wrong? > > Jeff > > > > > Jeff Fleitz wrote: > > I am working with master detail forms, in particular an Office Edit form > > that contains a child list to an OfficePhone table which store phone > > numbers and types. Right now there is a Filtered Select menu control on > > the OfficePhoneAddForm template which allows the user to select an > > office. I have been trying to use the whereClauseExtension and default > > attributes to filter the control to the specific foreign key passed to > > the form (URL.OfficeID) with no luck. Is there a way to do this? > > > > If not, what do you recommend as a 'best practice' for this type of > > scenario. This form will never be accessed from a standard list or > > search form, but only from a drilldown. Since I am passing the > > parentkey to the form, I am just looking for an easy way to get the > > foreign key (OfficeID) saved without having to add a custom query to the > > form. > > > > I guess the easiest way is to include a hidden field on the form using > > DisplayExtraFormContent, but I would like to be able to display the > > Office name on the form. > > > > Jeff > > > > > > ********************************************************************** > > 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 **********************************************************************
