Hello

 

I have a Subform related to a main form and I want to retrieve information based a third form , I wrote the code below and if a test that from the  subform itself this is  working, however when I test from the Main Form containing the subform and click on add row and then when I click on Nacionalidad field which is a lookup field trying to reduce the numbers of occurrence  the picklist candidato its not working, why is that?, which are the differences testing the subform isolated like a form from inside the main form?, its possible to do what I´m tryng with Subforms?.

 

 

Main Form Name containing the Subform = Alta_de_Open_Seats

Suform Name = Candidato

Third Form Name = Curriculums, here I have all the CVs from consultants

 

Logic is when the I click Country on the Subform I have to go to curriculums form and take all the Applicant_Names belong to that country specified on the subform.

 

if (count(Curriculums[Nacionalidad == input.Nacionalidad])  ==  0)
{
    clear Candidato;
}
else
{
    consu  =  Curriculums  [Nacionalidad == input.Nacionalidad];
    Candidato:ui.add(consu.Applicant_Name.getall());
}

Please let me know if for subform I need to change the code.

 

Thanks a Lot.

 

Victor