I have two forms form(A) and form(B) that both show data from the same table. I want to create a non-related portal on form(A) that shows form(B). The data in form(B) is only a subset of all the data in form(A) and is calculated using a method. When I come to view form(A), servoy just hangs.
Is it possible to show two differnet foundsets from the same table on one form???
I have a method that uses some custom sql to get the foundset to show in form(B).
Form A is for navigating though a list of individuals. Individuals are memebers of groups, so form B is a list of all members in the group that the individual in A is a member. I have to use a relation to another table to find out which group the individual in A is a member.