Hello Peter.

>> I created a form which display personal data for the supervisor and a command button which when click will open another form with a grid displaying all staff members of that department and supervisor assigned. <<

The easiest solution to your problem is to create a parameterized view for your staff members and supervisors by department. You can put the parameterized view in the date environment of the calling form with NoDataOnLoad set to true.

Then, in your modal pop-up form (I assume it is going to be a modal form), you can just set up the grid visually and use the parameterized view as its ControlSource. If the called modal form uses a default data session, it shares the datasession of the caller so it will "see" the parameterized view.

In order to get the correct data to show up in the grid, you just REQUERY your view using the correct department as the parameter.