D
Doug
[I have cross-posted this to m.p.a.gettingstarted and m.p.a.queries]
I have an application that I believe is very analogous to the Northwind
example DB (or any sales order db). The short version of what I am doing
is:
My technicians collect gauge readings daily from different mini-water
treatment plants. There is a site-specific form for each site that lists
each site specific parameter. The biggest difference between the Northwind
db and mine is the Products table. I want to change the Products tables to
a Parameters table. The parameters table will contain a list of the
different gauges/meters at each site. Each site will be a little different
in the number (30-60) and type of gauges/meters.
I haven't figured out yet how to modify the Order From (with subform) such
that instead of selecting the product you want to order, the list of site
specific parameters (30-60) shows up automatically in the subform.
I believe I need to modify and/or add a query and build the subform from
this query, but I haven't figured it out yet. Can anyone point me in the
right direction?
Analogy:
Northwind DB = My DB
Customers = Sites/Project
Orders = Field Visits
Products = Parameters
Thanks,
Doug
I have an application that I believe is very analogous to the Northwind
example DB (or any sales order db). The short version of what I am doing
is:
My technicians collect gauge readings daily from different mini-water
treatment plants. There is a site-specific form for each site that lists
each site specific parameter. The biggest difference between the Northwind
db and mine is the Products table. I want to change the Products tables to
a Parameters table. The parameters table will contain a list of the
different gauges/meters at each site. Each site will be a little different
in the number (30-60) and type of gauges/meters.
I haven't figured out yet how to modify the Order From (with subform) such
that instead of selecting the product you want to order, the list of site
specific parameters (30-60) shows up automatically in the subform.
I believe I need to modify and/or add a query and build the subform from
this query, but I haven't figured it out yet. Can anyone point me in the
right direction?
Analogy:
Northwind DB = My DB
Customers = Sites/Project
Orders = Field Visits
Products = Parameters
Thanks,
Doug