So I am ttempting to set up a database to manage budget forecasting and analysis for a large group of project managers. I have been able to use much of the information and examples on this forum to get to the point I am at, but I have encountered a stumbling block.
I have utilized a username and password managment utility that was posted on this site at an earlier date. Th problem I am having now is using that username/userid to drive values returned on forms for inputting budget forecasts.
The relevant Tables I have are:
tblUserDetails (includes: UserId, UserName, Password)
tblProjectDetails (includes: UserID, ProjectId, ProjectName)
How do I return a list of Projects that the current User is responsible for?
Thanks for the help
I have utilized a username and password managment utility that was posted on this site at an earlier date. Th problem I am having now is using that username/userid to drive values returned on forms for inputting budget forecasts.
The relevant Tables I have are:
tblUserDetails (includes: UserId, UserName, Password)
tblProjectDetails (includes: UserID, ProjectId, ProjectName)
How do I return a list of Projects that the current User is responsible for?
Thanks for the help