modifying Projects - See Example

[Jchristensen]

Hello, So far you guys have been helping me through my database that i am building. Thanks so far!

But at the moment i need help on one more aspect of this Database Job. Currently i have a database that supports and holds records for jobs that are under contract. That means we have certain numbers and statistics of Jobs and there properties.

what i have right now is a table with a couple fields. (there are more than this but this is just for example)

1. project number "primary key"
2. aerial units
3. buried units
4. planning units
5. ICGS units

That part works fine with the current table. But since jobs are under contract the number of units might change further on during the design and construction. There may be more than one mod.

Now the part that im stuck on is the most important. I need a table/query/form/report that i can input the changes to particular units. Like i said before there might be more than 1 mod. So i need to make it show ALL the mods ive done to a project.

This is a huge part, and any help would be very much appriciated.
~Thanks so much
Jon

 

[Vassago]

I did something similar to this a loooong time ago. There might be a better way of doing this, but what I did was create a form bound to the table with all fields available. Then I had hidden text boxes for each field that might be modified. On open and record change, the hidden fields would refresh to be exactly what the current record showed. When I modified something, I would have the system automatically write a stamp of sorts to another table with all values currently in the hidden fields, then a timestamp. Then the form would refresh itself so the hidden fields would take the new values. If another change was made, it would do this again. This would then allow me to query all changes made to my records by joining the main table with my changes table by the primary key of the main table.

Like I said, there's probably a better way, this was just something I threw together for myself for personal use on the job so I knew what changes I made.

 

[Jchristensen]

i dont know how to do this, if you could possibly show me an example of how this might be done id be happy.

I CANNOT figure this aspect of the database out