Documents

NextGrid & NextDBGrid

• Html Column Tutorial
• Upgrade existing projects for loading changes
• Edit events in NextGrid
• NextGrid Vista Style
• NextGrid How To
• Integrating Inplace Editors
• NextGrid Slide Style Tutorial
• InputLine Tutorial
• FieldChooser Tutorial
• Using Editors in runtime
• Grid Report Tutorial

NextGrid

• TreeColumn Tutorial
• NextGrid Quick Start
• Custom Draw in NextGrid
• Export to XML from NextGrid
• Optimize NextGrid
• NextGrid Custom Sorting
• VirtualColumn Tutorial
• Graphic Column Tutorial

NextDBGrid

• NextDBGrid Quick Start
• NextDBGrid Events
• NextDBGrid How To
• Sorting records in NextDBGrid
• LookupColumn Tutorial

NextInspector

• NextInspector Advanced tutorial
• ToolbarItem tutorial
• NextDBInspector Tutorial
• NextInspector Item Types
• Map VCL property to item
• NextInspector Quick Start

NextSheet

• NextSheet Sample Project
• NextSheet Quick Start
• Formating in NextSheet
• NextSheet Print Method

NextCollection

• NxAlertWindow Tutorial
• NxInfoPanel Tutorial
• Vista Styled Panels
• NxPathControl and NxNotebook tutorial
• NxPathControl Quick Start
• NxFlipPanel and NxHeaderPanel Quick Start
• NxOutlookBar Tutorial
• NxPageControl and NxNotebook Quick Start
• NxButton Tutorial

Misc

• Component Names Change
• NxComboBox styles
• Numeric FormatMask
• NxVirtualDataSet tutorial
• DateTime FormatMask
• NxPreview Quick Start
• 32bit Bitmaps Tutorial
• Quick update
• Enable typing unicode characters in InplaceEditors
• Using NxColorScheme
• NxProgress Tutorial
• NxAutoCompletion Tutorial

Labs

• NxReport Project

NextGrid .NET

• Working with tree
• Custom Drawing in NextGrid dot NET
• NextGrid Dot Net
• NextGrid Dot Net Events
• NextGrid dot NET Quick Start

Related Articles:

Introducing

With using Lookup Column we can combine Fields of 2 Tables or Queries to get result similiar when using SQL Join commands.

Sometime we need to represent Field from first table with using Values from second Field. To do this, we need to link this 2 Fields with using properties from TNxLookupColumn.

TNxLookupColumn is located at the secong "Tab" inside Next DBGrid Columns Editor.

Example Tables

In this example we have 2 tables: Articles and ArticleTypes.

We need to link ArticleTypeId Field from first Table to Id Field from second Table.

Set Lookup Column

Now, we will set TNxLookupColumn:

1. Place 2 TTable (TADOTable, TIBTable, TZTable...) components and 2 TDataSource components on form.
2. Place NextDBGrid on Form and add one TNxLookupColumn.
3. Select this column and set next properties
4. Property FieldName will be set as usual to desired Field from first table - "ArticleTypeId"
5. Property KeyFieldName - Key Field from ArticleTypes Table. This property will have "Id" as Value.
6. ListDataSource - Set to second DataSource
7. ListFieldName - Set to displaying Field from second Table. In our case is "Name".