A
Air-ron
I have a form that I'm using to select the paramaters to open a second form
(or possibly a subform)
The data structure is this:
The main table stores head count records using Vendor, Zone, and Time fields
as a primary key. Each one of those has a table storing the different
possible values, with a table linking zones to vendors. The time values are
related to a Shift Table, showing which times are counted by which shifts.
The form contains controls where the user can pick a Shift, a Date, and a
Casino Floor. Once those three are picked, I'm envisioning a button that
runs a script that:
1) Checks if there is already data for the specified date, Shift, and Floor
2) if no data exists, Create records for each vendor within each zone
(specified through the ZoneVendor link table) with zero (not null) values for
the headcount.
3) open a form that allows all of these values to be edited at one time.
I imagine I'll need to create a query for the form part, but the checking
and creating new records is what I'm confused about.
Aaron
(or possibly a subform)
The data structure is this:
The main table stores head count records using Vendor, Zone, and Time fields
as a primary key. Each one of those has a table storing the different
possible values, with a table linking zones to vendors. The time values are
related to a Shift Table, showing which times are counted by which shifts.
The form contains controls where the user can pick a Shift, a Date, and a
Casino Floor. Once those three are picked, I'm envisioning a button that
runs a script that:
1) Checks if there is already data for the specified date, Shift, and Floor
2) if no data exists, Create records for each vendor within each zone
(specified through the ZoneVendor link table) with zero (not null) values for
the headcount.
3) open a form that allows all of these values to be edited at one time.
I imagine I'll need to create a query for the form part, but the checking
and creating new records is what I'm confused about.
Aaron