Thanks Marina, that looks good. Will try it out.
Chris Milne Application Services Department Data Aspects Pty Ltd From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marina Krynina Sent: Friday, 22 August 2008 14:22 PM To: [email protected] Subject: Re: [OzMOSS] RE: Filter lookup drop-down box Have a look at Query Based Lookup Field: http://www.codeplex.com/CustomFieldControls On 8/20/08, Chris Milne <[EMAIL PROTECTED]> wrote: Thanks for your suggestions. Looking into BDC I see that it's an Enterprise only feature and we're running MOSS 2007 Standard so that's not an option. I'm not familiar with creating custom field types but looking into it I see that it can be done using VSeWSS, which I have not got running yet as it has to run on a server platform. I'll investigate that further when it's running, thanks for your help. Chris From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ishai Sagi Sent: Thursday, 14 August 2008 15:06 PM To: [email protected] Subject: [OzMOSS] RE: Filter lookup drop-down box I cant think of a way to do it except either a custom field, or set up a BDC web service for this. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Milne Sent: Thursday, 14 August 2008 12:15 PM To: [email protected] Subject: [OzMOSS] Filter lookup drop-down box Hi all, When creating a new list item, I am trying to find out how I can filter a drop-down box (a lookup to another list) based on another field of the foreign list. I have these lists set up: List A. Fields are: ID, Enabled (Yes/No) List B. Fields are numerous, including one lookup to the ID field of List A. When I create a new item in List B, I'm presented with the lookup drop-down box containing all ID's from List A. I only want to display ID's in that drop-down if their corresponding 'Enabled' field is set to yes. I had achieved this using a Javascript that removed all elements from that drop-down, and repopulated it only with 'enabled' items, which worked fine. However, since SharePoint renders drop-downs as a <select> if under 20 elements, and as an <input> if it contains >20 elements, this JS only works if there are less than 20 elements in List A. (see http://forums.msdn.microsoft.com/en-US/sharepointdevelopment/thread/4c96 520a-bf28-4877-915a-2e615e8d1ebf/) Can anyone tell me if there is another/better way of achieving this? Kind regards, Chris ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com <http://mailenable.com/> ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com <http://mailenable.com/> ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com <http://mailenable.com/> -- Cheers, Marina ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
