Ever design a db to track serial numbers thru mfg?

[Jeff Meteyer]

I wanna design a database where I can track serial numbers that go thru
different operators and different stations. I want to time stamp each entry,
and I want the operator to sign in once and have their ID post to each record
while their login is active

 

[John Vinson]

On Sun, 16 Apr 2006 17:44:02 -0700, Jeff Meteyer <Jeff

I wanna design a database where I can track serial numbers that go thru
different operators and different stations. I want to time stamp each entry,
and I want the operator to sign in once and have their ID post to each record
while their login is active

Ok, sounds reasonable. Go right ahead!

If you're having some specific problem doing so, please explain, and
we'll be glad to try to help. A further explanation of what you mean
by "have their ID post to each record while their logon is active" in
particular would be helpful - taken literally, that would mean that
every serial number in your database would get stamped with every
user's ID whenever they log on, which is surely not what you mean!

John W. Vinson[MVP]