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???
Thanks
Simon
how do you set a foundset in Form B?
If it is not related then Form B should have a seperate foundset (this is a form property)
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.
just make sure that form b has a seperate foundset. If both are shared then the use the same foundset so one must be seperate. (a or b)
Thanks, sorry I overlooked the use seperate foundset option!
Cheers