share login id with other tables - TechRepublic
Question
March 18, 2009 at 10:08 PM
cyndeecollinsconsulting

share login id with other tables

by cyndeecollinsconsulting . Updated 17 years, 3 months ago

I have a very simple login table with id, name, password. I have the login part working fine. On each table in the db I also have the personID field and a datetimestamp field. We just need to know who added the record and when. So when the record is added, I want “anytable.personID” to equal “logintable.personID”. I am not sure how to do that on my form. This is in Access 2003

This discussion is locked

All Comments