I have two tables.
1) tbl_Information - which carries all of my information that I will be primarily messing with.
2) Users - this is used during the first login of the database and basically registers them and their computer to the database.
What I am wanting to do in my form is have a combo box that will display all the names that are registered with the database.
What I am trying to do is create the ability to assign work to that specific person. Please ask questions if none of this makes sense and I will provide my query SQL that I have so far.
Thanks in advance.
1) tbl_Information - which carries all of my information that I will be primarily messing with.
2) Users - this is used during the first login of the database and basically registers them and their computer to the database.
What I am wanting to do in my form is have a combo box that will display all the names that are registered with the database.
What I am trying to do is create the ability to assign work to that specific person. Please ask questions if none of this makes sense and I will provide my query SQL that I have so far.
Code:
SELECT Tbl_Information.*
FROM Tbl_Information LEFT JOIN Users ON Tbl_Information.UserName = Users.UserName
WHERE (((nz([fllwDate],Date()))<=Date()) AND ((Tbl_Information.Cleared)=False))
ORDER BY nz([fllwDate],Date());
Thanks in advance.