HI All,

I am having two custom objects 1)  Roof Details__c  2) Electric Usage__c ( lookup to Roof)..

I want to put filters in the lookup on Electric usage record on below criteria

• If  Electric usage record is associated with Roof Details like " Ex: ROOF A" then it shldn't show " ROOF A" if  someone wants to associate with  same "ROOF A" record.

 We just need to show the ROOF B, C, D...... in the lookup filter  that are not associated with the other ....

Please help me ??? Thanks in Advance ...

Let me know if you need more explanation or not clear about the question ??

Thanks,

Chenna