Consider this scenario.
There are two forms, Form A and Form B.
In Form A, there are ID and Cluster Name as fields.
The problem is in form B, I need to display the ID that have the same cluster name in a field called Common. For the cluster name in form B, it is autoupdated by a subform. I have try to use SQL statement but it cannot works.
The SQL statement i type is "SELECT distinct ID FROM table A WHERE (table A.cluster name = table B.cluster name)
The result of this SQL statement is that it display all the IDs that have the same cluster name plus those with different cluster name. This means it display all IDs that have cluster name which is not I want. I want it to display IDs that have the same cluster name in form B. Could someone please help me?? Thanks