Subject KeyLinks, Join Links... Am I doing this right?
Author Paul Irwin
Here's my scenario. I have a users table and a sessions table. The
sessions table will be frequently updated as users log in and out. I want
to display a grid of which users are currently logged in.

Table 1 - Sessions
Fields
Session_ID (PK)
User_ID (FK -> Users.User_ID)
Location
Start_Date

Table 1 - Users
Fields
User_ID (PK)
Login_Name
Login_Password

SQL - select Sessions.*, Users.Login_Name from Sessions, Users where
Users.User_ID = Sessions.User_ID;

KeyLinks
Sessions.Session_ID

JoinLinks
Users.User_ID = Sessions.User_ID


This setup works, but I'm not sure if this is as it should be. Thank you
for any input you have.

Paul