Seeing all records in a related foundset

Classic Servoy
1

Here’s the scenario:

  1. Two tables A and B. B has a foreign key related to A’s primary key in a one-to-many relationship A to B.

  2. I search in A and get a specific foundset. I then want to be able to go to a form attached to B and look at ALL records in B that relate to the foundset in A.

How do I do this? If I use controller.showRecords(A_to_B) to load the records into the form attached to B, I (of course) only see the 1 record that relates to the current record in A.

Is there a way of passing the pk’s that are in A’s foundset to the fk’s in B to get this to work?

Thanks!

2

And a little add-on:

to set the pointer on the choosen record in the portal.

3

Check out the ConvertFoundSet() function in the database manager node.

  • David