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

Reply via email to