[AccessD] Northwind 2007 question

[jack drawbridge]

Arthur,

I haven't done much with Northwind 2007. I just opened a copy I had someone
send me a while back. What I'm seeing is that the Active Orders is a
subform and the data linkage Masterfields/ChildFields is done via the
cboCurrentEmployee  on the mainform  linked with Employee Id on the subform.

Jack

On Mon, Mar 28, 2016 at 10:40 AM, Arthur Fuller <fuller.artful at gmail.com>
wrote:

> Since I don't have v. 2010 or beyond, I don't know whether the Northwind
> sample application has changed. The 2007 version has changed considerably,
> in terms of user interface, from previous versions. Most immediately
> apparent is the lack of a starup form that functions as the app-menu.
> Instead, the opening form resembles a dashboard, with relevant information
> and action-items presented at once.
>
> Actually, the opening screen is a login form, followed immediately by the
> dashboard. This form contains a couple of subforms, one of which is a
> datasheet listing active orders for the current user. The datasheet is
> based on a SELECT statement, but the SELECT makes no mention of the current
> user. I'm not seeing how this query is restricted to the current user, but
> somehow it is. I know this because when I grab the SELECT statement and run
> it as a query, I get the active orders for all users, not just the current
> one.
>
> Has anyone familiar with this sample app got an idea how this is achieved?
> Perhaps it has something to do with the Parameters table?
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>