Hello,
I need help with a database that I am setting up that will be uploaded to sharepoint. This is an access 2007 db.
In my database I have the following tables (no forms/reports/or queries except for queries nested in the tables):
Employees
Accounts
Projects - NOTE: in the Projects table I have an Accounts column which is has a one to many relation with the accounts table, and it's doing a lookup from the accounts table]
Time Reporting
____________________
My problem is with the setting up the time reporting table.
In the time reporting table I have the following columns:
AccountID [Drop down list - lookup from accounts table, ProjectID lookup from projects], Employee, etc.
I need to find a way to set it up so that when a user goes to report time:
And selects an accountID from the drop down list, when they click on the projects drop down list, they only see projects for the account that they have selected.
I am looking for any insight that I can find.