You could add 3 datasources to your form, 1 for the table t1 an 2 for the table t2, let’s call them t2a and t2b
In your form, base your first grid on t1 and the second grid on t2b
In the properties of the t2a, select t1 in the property JoinSource and use ExistsJoin in the property Link Type; and for the datasource t2b do not select JoinSource and leave the default value(Delayed) for the property Link Type.
Then use a dynalink to filter the records of the second grid overriding ExecuteQuery of the datasource t2b:
public void executeQuery()
{
//fieldName would be the names of the fields that relates t1 and t2
U tried ACTIVE…it also shows two datasource records means like when u r clicked table1 records in one form other form shows that table1 related field in table2…when u click other record it will automatically shows that related records once u try…