How does one pass search criteria to a grid application? I have a client with a tree menu of 70 vendors. I really don’t want to create a new application for each vendor. That would be a maintenance nightmare.
Re: Calling an application with search criteria.
first your database structure need match your criteria.
So, for each table you need a field to determine from witch vendor that records belong.
When you create the grid, simple use SELECT FIELDS FROM TABLE where venderid = ‘[vendorid]’
at the login you must create this variable ([vendorid]) based on the vendor id of the login.