LookUpEdit, GridLookUpEdit, and SearchLookUpEdit controls can automatically filter their data sources based on a value in another lookup.

Use the secondary lookup's CascadingOwner property to specify the primary lookup. Lookups use an internal algorithm that identifies a key field in a data source. The algorithm checks the names of data objects, the key attributes, and the data type of the primary keys. The algorithm is based on a common naming convention of key fields (for example, ID, Key, and OID).

Use the CascadingMember property to manually specify a key field of the secondary lookup if the lookup's algorithm cannot identify a key field. Use the ; character to delimit field names in a compound foreign key field.

Read the following help topic for additional information: Cascading Lookups.

• DataProvider.cs (VB: DataProvider.vb)
• Main.cs (VB: Main.vb)

• Cascading Lookups
• Lookup Main Settings
• WinForms Lookup Editors