G
Guest
Created simple Reports tracking database for reports going to outside
agencies in Access 2000.
Consist of tables with fields: Permit Info (Permit_Number (PK), Type_Permit,
Responsible_ Person, Department, Regulatory_Agency), Report Name (EventID
(PK)), Report_Name, Monitor_Rqmt), Report Frequency (Frequency), Month
(Month_Name, Month_Nr (PK)), Installation (Installation_Name, UIC (PK)),
Command (Command_Name, UIC (PK)), and Activity (Activity_Name)
The Layout - the permit numbers are specific to an Installation and may
apply to multi Commands and Activities. Report Name will apply at multiple
Installations, Commands, Activities. Report Frequency consists of Annual,
Semi-Annual, Quarterly, Monthly and some occassional weird rqmts such as
every 6 years etc (Did not set up predetermined peiod start and ends
timeframes because the quarterly and semi-annual periods are not always the
typical quarter, semi-annual). Month is typical with a thirteenth month named
Varies - this table fills the Month_Due, Period_Begin and Period_End fields
on the data entry form. Installation lists physical location, Command lists
commands (can have more than one on same installation) and Activity lists the
actual department (Maintenance, Facilities, etc.
Problem - when I make a change in any of the tables, such as Report Name, I
run the query but my Data Input Form does not change the name in exisiting
records. I use a Data Input Form to populate a Reports Data Info database.
It does show the new name on the Data Input Form (combo box linked to the
query) for a new record. I'm sure I'm overlooking some part of the data
relationship. I did a drag and drop of the fields in the tables to the
Reports Data Info database fields, thinking this will allow the automatic
updata if I changed any of the information in the tables.
What am I missing?
--GI Smith
agencies in Access 2000.
Consist of tables with fields: Permit Info (Permit_Number (PK), Type_Permit,
Responsible_ Person, Department, Regulatory_Agency), Report Name (EventID
(PK)), Report_Name, Monitor_Rqmt), Report Frequency (Frequency), Month
(Month_Name, Month_Nr (PK)), Installation (Installation_Name, UIC (PK)),
Command (Command_Name, UIC (PK)), and Activity (Activity_Name)
The Layout - the permit numbers are specific to an Installation and may
apply to multi Commands and Activities. Report Name will apply at multiple
Installations, Commands, Activities. Report Frequency consists of Annual,
Semi-Annual, Quarterly, Monthly and some occassional weird rqmts such as
every 6 years etc (Did not set up predetermined peiod start and ends
timeframes because the quarterly and semi-annual periods are not always the
typical quarter, semi-annual). Month is typical with a thirteenth month named
Varies - this table fills the Month_Due, Period_Begin and Period_End fields
on the data entry form. Installation lists physical location, Command lists
commands (can have more than one on same installation) and Activity lists the
actual department (Maintenance, Facilities, etc.
Problem - when I make a change in any of the tables, such as Report Name, I
run the query but my Data Input Form does not change the name in exisiting
records. I use a Data Input Form to populate a Reports Data Info database.
It does show the new name on the Data Input Form (combo box linked to the
query) for a new record. I'm sure I'm overlooking some part of the data
relationship. I did a drag and drop of the fields in the tables to the
Reports Data Info database fields, thinking this will allow the automatic
updata if I changed any of the information in the tables.
What am I missing?
--GI Smith