Description: Lookup is nothing but we can see easily other table data in other form or table. When we have to fill Marks data based on student Name or Student ID then we are storing Only ID Field in Column that time we have to See ID and Name in Lookup it Means Drop down. So We Can Easily Select and Filled Data in Controls.
Step 1: Create Table
Name it “A_Student”. And Drag and Drop ID & Name Field in Auto Lookup Field Group Node.
- Expand AOT Node.
- Open Data Dictionary Node.
- Select Tables and right Click Select New Table.
- Name it “A_Student”.
- Now open table in Insert Some Data in A_Student table.
Step 2: Now Create
Form and Name it “TableMethodForm”.
- Expand AOT Node.
- Select Form Node and Right Click Select New Form and Name it “TableMethodForm”.
- Now Drag and Drop Table in Form Data Source.
- Select Design Node Right Click and Select New Controls & Add Grid Controls in Design Node.
Step 3: Now select Student ID Field form Design Controls and Override Lookup Method.
Step 4: Create Custom
Code for Lookup and Create Query, QueryBuildDataSource, and QueryBuildRange and
Perform Lookup in A_StudentForm.
Step 4: Create Display
Method in table for Retrieve Student Name from A_Student table and Display in Look Up.
- Expand AOT Node.
- Open Data Dictionary Node.
- Select Tables.
- Select Method Node right Click Select New Method.
Step 5: Now Change
Name and Create Display Method and Code for Retrieve Name from Student Table.
Step 6: Now Open TableMethodForm.
Thanks for comments.....