You need to sign in to do that
Don't have an account?
search function using loolup
hi,
i have obj named patient_receipt__c, it has lookup field for patient name, if i select the name and click search it should display the details ..but it is not working and i don't knw where i did mistake..
my controller:
public class viewrec
{
public String temp;
Public Boolean show{set;get;}
public Patient_Receipt__c pr{get; set;}
Public list<Patient_Receipt__c>prlst{set; get;}
public viewrec()
{
pr= new Patient_Receipt__c();
show= false;
}
public pageReference fees()
{
if(pr.Name__c!= null)
{
temp=pr.Name__c;
//prlst= (list<Patient_Receipt__c>)[select Name__c,Registration_Number__c,Age__c,Diagnosis_Fees__c,E_C_G_Fees__c,Indoor_Injection_Fees__c,Lab_Fees__c,X_Ray_Fees__c,Total_Fee__c from Patient_Receipt__c WHERE Name like: temp];
pr= [select Name__c,Registration_Number__c,Age__c,Diagnosis_Fees__c,E_C_G_Fees__c,Indoor_Injection_Fees__c,Lab_Fees__c,X_Ray_Fees__c,Total_Fee__c from Patient_Receipt__c WHERE Name =: temp];
show= true;
}
System.Debug('pr');
return null;
}
public pageReference clr()
{
show=false;
return null;
}
}
my page:
<apex:page controller="viewrec" >
<apex:form >
<apex:pageBlock >
<apex:pageBlockSection >
<apex:inputField value="{!pr.Name__c}" label="Patient name"/>
</apex:pageBlockSection>
<apex:pageBlockButtons location="bottom">
<apex:commandButton value="view fee details" action="{!fees}"/>
<apex:commandButton value="Clear" action="{!clr}"/>
</apex:pageBlockButtons>
<apex:pageBlockTable rendered="{!show}" value="{!pr}" var="d">
<apex:column value="{!d.Name__c}" />
<apex:column value="{!d.Registration_Number__c}" />
<apex:column value="{!d.Age__c}" />
<apex:column value="{!d.Diagnosis_Fees__c}" />
<apex:column value="{!d.E_C_G_Fees__c}" />
<apex:column value="{!d.Indoor_Injection_Fees__c}" />
<apex:column value="{!d.Lab_Fees__c}" />
<apex:column value="{!d.X_Ray_Fees__c}" />
<apex:column value="{!d.Total_Fee__c }" />
</apex:pageblockTable>
</apex:pageBlock>
</apex:form>
</apex:page>
hi ,
I think we can use trigger also for this
i have a sample trigger
trigger tregistration on book__c(after insert)
{
for(book__c b:trigger.new)
{
list<registration__c> rlist=[select bookname__c,bookid__c,authorname__C from registration__C where bookid__c=:b.bookid__c];
registration__c r=new registration__c();
r.bookname__C=b.bookname__C;
update r;
}
}
It may useful to you..........
A lookup will populate an ID, not a name. So if you then try to use that value in a SOQL query, you'll need to match on the id.