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