Hi All,

I have a tabbed form with a company page and a contacts page, what I want to be able to do is when I click on the contacts page it shows all the contacts at the company. I can do this easily using a grid with the contacts table as the recordsource which relates to the companyid in the company table. I want to modify the code to use a local parameterized view for the contacts page. I've created the view and added it to the forms dataenvironment, but when I click on the contacts page the contacts grid is empty

My view was created using the following code:
CREATE SQL VIEW contacts_view AS SELECT * FROM contacts ;
WHERE companyid = ?companies.companyid

I haven't used Views much and I was kind of hoping that the view would refresh when COMPANIES.COMPANYID changed, is this wishful thinking? Is there a way to do a ReQuery on the grid so that the parameterized view is refreshed with the contacts from the chosen company? Can someone please point me in the right direction?


Thanks,
Gavin...