Multiple Tables

[illy2k]

I have two tables linked by a ItemNumber. One table is a history table, showing everytime an item is checked in or out. The other table is an updating table no new records are added, all that happens is when an item is checked in or out, the record for that ItemNumber updates the status to in or out. Is there anyway I can have this happen?

 

[Rich]

Why do you need a second table to indicate wether an item is in or out?

 

[illy2k]

Because

I need a history record, so I can check for exceptions, like if an item was checked out but not back in, and I need an updating record of the status so they can use a report to show where the item is at the present moment.

 

[illy2k]

bump

bump

 

[Rich]

Don't you have datein date out fields in your table?

 

[illy2k]

It doesn't matter

It is hard to explain, but it works if I can get that one piece of data to be sent back to two tables. Does anyone know how to do it?

 

[dat_guy]

/tag
I wanna be able to find this later.