I have a table with data in the following structure:
RuleNumber Scale
1 A
1 F
1 D
2 B
2 C
3 C
3 B
...
1000 records
I would like to put rule 2 and 3 into one group because they have identical scales. (Max number of scales to a rule is 6.) I would like to put all such identical rules in groups and than have a form to display the groups - each group on a single form, and display the rules that belong to that group. Click and se the next group. Sometimes of course there would only be one record in the group.) Like in this case:
GroupID RuleNumber
1 1
2 2
2 3
Does anybody have an idea how to do that? Many thanks.
SWK
[This message has been edited by SunWuKung (edited 01-13-2002).]
RuleNumber Scale
1 A
1 F
1 D
2 B
2 C
3 C
3 B
...
1000 records
I would like to put rule 2 and 3 into one group because they have identical scales. (Max number of scales to a rule is 6.) I would like to put all such identical rules in groups and than have a form to display the groups - each group on a single form, and display the rules that belong to that group. Click and se the next group. Sometimes of course there would only be one record in the group.) Like in this case:
GroupID RuleNumber
1 1
2 2
2 3
Does anybody have an idea how to do that? Many thanks.
SWK
[This message has been edited by SunWuKung (edited 01-13-2002).]
