Hi.
I have moved my data from Access to SQL Express, and linked the tables to the Access frontend.
I have made views for the "biggest" queries that has a lot of calculations.
Before I upsized, I restricted the amount of records calculated by using criteria from the customer form (frmKundekort) with the primary key being accountID.
So all other relevant queries for reports and a bunch of other things, has forms!frmKundekort.accountID as a criteria in the underlying queries.
This does not work with the sql view.
So my question is, what is "best practice" for narrowing down the amount of records transfered from sql to the frontend? How to put in a WHERE clause in the sql view, so it only returns records related to the relevant accountID in the form frmKundekort?
Comments or examples are greatly appreciated...
I have moved my data from Access to SQL Express, and linked the tables to the Access frontend.
I have made views for the "biggest" queries that has a lot of calculations.
Before I upsized, I restricted the amount of records calculated by using criteria from the customer form (frmKundekort) with the primary key being accountID.
So all other relevant queries for reports and a bunch of other things, has forms!frmKundekort.accountID as a criteria in the underlying queries.
This does not work with the sql view.
So my question is, what is "best practice" for narrowing down the amount of records transfered from sql to the frontend? How to put in a WHERE clause in the sql view, so it only returns records related to the relevant accountID in the form frmKundekort?
Comments or examples are greatly appreciated...