My form wants to link to several grids in detail-link. I create the first detail and link it to grid_1. great, no problem. I go to link grid_2 and it says “Without Parameters”? How do I link a bunch of grids to a single form using the same linking field in the form?
Ok, figured it out (I think). You need to modify the sql statement in the grid you want to call to include a where clause like this:
WHERE
project_id = ‘[vProject_Id]’
Then when you set the new detail in the master form you can link it on vProject_Id = {PROJECT_ID}
Do I have this right?
Although it seems like this limits the grid you are calling to be filtered on that field. If anyone can shed further light on this it would be appreciated.