Tracking History

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Use a subform for History within the Properties form. Link
using the ID field in the Properties table and the
Property ID field in the History table.

When a property is shown on the property form, all history
will load in the subform for that specific property.
-----Original Message-----
Currently I am working on a inventory database. I have 3 tables
1 - Client Info: company, address
2 - properties: size, wieght, ID, contents
3 -HIstory: shipping date, received date, location, and property ID

I'm trying to keep track of when we ship a crate, where
Click to expand...
is been, when it came back, and its new location in the
warehouse. The forms are pulling data from the tables.
Is there something that I need to code or a field that I
need to change in order for it to keep a histroy.
Currently its just changing the table.
 
I've done that, but It still just changes the table and does not keep a history. I need to keep track of where the crate has been for the last 7 years. (dates and locations)

any other suggestions?
 
Back
Top