Tracking History

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 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.

Please help....thanks


--
Thanks,
Jodie

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
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.

Please help....thanks


--
Thanks,
Jodie
.

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?
--
Thanks,
Jodie


" wrote:

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
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.

Please help....thanks


--
Thanks,
Jodie
.