Ever design a db to track serial numbers thru mfg?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Meteyer - 17 Apr 2006 01:44 GMT

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

Reply to this Message

John Vinson - 17 Apr 2006 08:04 GMT

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

Reply to this Message