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/4c96520a-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 > > ------------------------------------------------------------------- > 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 > -- 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
