hi @emmanuelmeza62 

Below are few links that would help you to understand on the PXSelector 

PXXelector syntax 

PXSelector and Dirty Read - Acumatica Developers Blog

PXSelector example 

PXSelector for custom table | Community (acumatica.com)

PXSelector Quick search 

Acumatica Filtering PXSelector witth quick search - Stack Overflow

Please let us know if your looking for something specific. 

Hi, I’m new with Acumatica, and I have a question about load data with a PXSelector. I need add the data in some fields of the Grid and other in a form, but I don’t know how to do that. Help, please. 

Can you please confirm that that the fields, which you wanted to show are saved in the database, in other words, all are bound fields?

@Naveen B  Hi, yes the data are saved in the database, but I don’t know how to show the data in other fields,for example, in this case I want put the data “numLicencia” in the region with the same name.

Hi @emmanuelmeza62  When you wanted to display the Form and Grid values in the selector, then you should use the Inner Join  (SEARCH2<>) in the selector and provide the Fields, which you wanted to display.

Below is the sample example for your reference and hope this helps!!

  #region SelectorBranchID
         PXDBString(255, IsUnicode = true, InputMask = "")]
         PXUIField(DisplayName = "Branch", Enabled = false)]

         PXDefault(typeof(Search<Branch.branchCD, Where<Branch.branchID, Equal<Current<AccessInfo.branchID>>>>))]

         PXSelector(typeof(Search2<Branch.branchCD, InnerJoin<BAccount, On<BAccount.bAccountID, Equal<Branch.bAccountID>>>>),
                    typeof(Branch.branchCD), SubstituteKey = typeof(Branch.branchCD), DescriptionField = typeof(BAccount.acctName))]
        public string SelectorBranchID { get; set; }
        public abstract class selectorBranchID : BqlString.Field<selectorBranchID> { }
        #endregion