Linking Question

M

Mike

I am not really sure what i want to do with this, so I will explain my
intentions and see if anyone can come up with a better method.

I have a sign inventory. 3 field in this inventory relate to installation
detail, install date, installed by, and install comments. At this point this
is just a standard field that can be updated as needed. What I want to do is
have the ability to provide a sign installation history.

I want to keep track of the sign installation detail, even if changed I want
to have the data that was in there, so that with a push of a button, the sign
history can come up and users can review it.

Not clear on who to implement this.

I am thinking, having a installation information table that can add a new
record when the installation fields are updated. Or possibly a button that
can take users to a subform to enter the installation data directly into the
secondary table. The installation detail would need to be tied to the sign
record, I assume through the sign ID number field.

Any help would be appreciated, or better ideas on how to implement.
 
M

Mike

Mike said:
I am not really sure what i want to do with this, so I will explain my
intentions and see if anyone can come up with a better method.

I have a sign inventory. 3 field in this inventory relate to installation
detail, install date, installed by, and install comments. At this point this
is just a standard field that can be updated as needed. What I want to do is
have the ability to provide a sign installation history.

I want to keep track of the sign installation detail, even if changed I want
to have the data that was in there, so that with a push of a button, the sign
history can come up and users can review it.

Not clear on who to implement this.

I am thinking, having a installation information table that can add a new
record when the installation fields are updated. Or possibly a button that
can take users to a subform to enter the installation data directly into the
secondary table. The installation detail would need to be tied to the sign
record, I assume through the sign ID number field.

Any help would be appreciated, or better ideas on how to implement.
Click to expand...

I have updates -

I now have two buttons on my main display form. Button one - Update Sign
Installation Detail opens a installation detail form, where the user must put
in the Sign ID, Date, Crew, Comments.

Button two - View Sign History opens a Sign History Form, listing all sign
installation details related to the Sign ID, this is just a listing.

Issues/Wants - I would like to have the installation detail form,
automatically grab the Sign ID is possible.

I would like the most current sign installation detail to be displayed on my
main form. Not sure how this would work, as I would need to filter the sign
installation details by ID and most recent date.

Thanks for the help.

Mike
 
T

Tony Toews

Mike said:
I have a sign inventory. 3 field in this inventory relate to installation
detail, install date, installed by, and install comments. At this point this
is just a standard field that can be updated as needed. What I want to do is
have the ability to provide a sign installation history.

I want to keep track of the sign installation detail, even if changed I want
to have the data that was in there, so that with a push of a button, the sign
history can come up and users can review it.
Click to expand...

There's a simple example at
ACC2000: How to Create an Audit Trail of Record Changes in a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197592

Audit Trail - Log changes at the record level at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html
The article addresses edits, inserts, and deletes for a form and
subform.

Modules: Maintain a history of changes
http://www.mvps.org/access/modules/mdl0021.htm
The History Table routine is designed to write history records that
track the changes made to fields in one or more tables.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top