Data relation is required to apply foreign key relation between dataset tables.
Data relation will provide following features:
- Child records will not accepted without parent record.
- Parent record can't be modified or deleted when child records are exists.
- Parent record will be modified or deleted by applying to child records.
Dim r as Data.DataRelation
The above code will establish relation by applying parent column with unique key constraint and child column with foreign key constraint.
Comments/Suggestions are invited. Happy coding......!