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)