samona

thanks a lot roopurt, I really appreciate you taking the time to reply to my post. Regarding Joins, I know them but I'm not sure what would be the primary key in the third table. In order to differentiate between the different tasks I would need to have the information in all three columns. So would the combination of user_id,task_id, and Datetime, be the primary key?

Hi All, After hours of thinking how to create this database of daily tasks I came up with the following tables. I have a 'User' table which describes a UserID and the user. I have a 'Tasks' table which describes a TaskID and the task information. I have a predicament. I want to create a table where I list the specific TaskIDs and then fill in the UserID of the person who completed the task, along with the time he/she finished the task. If I had a table that was just for one day, it would be simple enough. But how am I going to fit "TaskID,UserID,Time" for each day into one table? I probably need more than one table for this, but I just cant' think of it. Can someone give me a bump in the right directions? Thanks in advance.

That makes sense thanks, but now i'm a little confused on how i will connect the tables I have. I have a User table, a Task table, a Calendar table that contains days 1 -31, and now a Log table. The primary key in the User table is the UserID; The Calendar table does not have a PK it has a foreign key UserID. and the Log table does not have a PK it has a foreign key UserID. The Task table consists of tasks that must be completed each day. What I need to do is record who completed that task and at what time did they complete that task that day. Do the tables I use make sense for this?

Hi all, I was wondering if there is a way to log every sign in a user makes. For example, I want to be able to store when a user was logged in and how many times during that day he logged in. This way I can have an archive I can go back to and find out who was logged in between hour1 and hour2 on any given day. If it is possible, can you please help me out because I don't know where to start. Thanks!

Thank you, I will try that.

First of all, I would like to say this is my first time here. I am looking forward to being a participant in this forum Next, my question: Is it possible to print information from multiple databases on one page/form. For example, I want to print information that is in three databases, and I want to be able to print a few related fields on one page. Is that possible? Thank you for your help in advance.