Membership database - need to update usage with Check In button

[crowena63]

I am creating a database form so employees at our community pool can check in season pool pass holders. Essentially I have it set up so they search for the member by phone number or name. I want to have it st up so they click a button that says check in, and that would create another table/log on the memberID checking in and the date and time stamps. I've done some research, but I'm still a little foggy on how to do this.

[PhilOfWalton]

You've got the guts of it correctly.
Lets call the new table

TblVisits
    VisitID      AutoNumber   PK
    MemberID     Long
    DateTimeIn   Date
    DateTimeOut  Date
 

That is assuming there is both an In & Out time wanted.

Things are quite different if the Out time is used, because, if only an In time is used, we need to devise a method of ensuring that the same person isn't logged in twice, a few minutes apart. If the Out time is used, then we can perform a check that members have to be out before they are logged in and equally they have to be in before they are logged out.

The table design may need modifying, depending on which option you choose

Phil