Hello all,
I have the following situation within my database:
tblJobs is my list of job numbers
tblWorkHours is my list of hours worked by the various employees of the company, these work hours are linked to a job number number from tblJobs
I have set-up a query that effectively acts as a filter so i can display the work hours for a set of selected job number (not just one job number at a time).
The way i am doing this is in the tblJobs table i have a field called 'ShowInList' which is a Yes/No field, this field is modified through a form. If a job number is set to Yes, it
will display in my query.
This is working OK up to now, but my problem arises when i split the database in the local office network so it can be used my multiple users.
Of course what is happening now is that if two users try to use the filter form they are forced to have the same job number selection as this is done directly in the tblJobs table which is common to all users accessing the data...
Would anyone have any advice on how i can get around this problem?
So i would like to be able to select multiple job numbers from my tblJobs list (so that all work hours from tblWorkHours that matches the selected job numbers in tblJobs can be displayed in a query), but in such a way that each user of the split database can have their own job number selection.
I have the following situation within my database:
tblJobs is my list of job numbers
tblWorkHours is my list of hours worked by the various employees of the company, these work hours are linked to a job number number from tblJobs
I have set-up a query that effectively acts as a filter so i can display the work hours for a set of selected job number (not just one job number at a time).
The way i am doing this is in the tblJobs table i have a field called 'ShowInList' which is a Yes/No field, this field is modified through a form. If a job number is set to Yes, it
will display in my query.
This is working OK up to now, but my problem arises when i split the database in the local office network so it can be used my multiple users.
Of course what is happening now is that if two users try to use the filter form they are forced to have the same job number selection as this is done directly in the tblJobs table which is common to all users accessing the data...
Would anyone have any advice on how i can get around this problem?
So i would like to be able to select multiple job numbers from my tblJobs list (so that all work hours from tblWorkHours that matches the selected job numbers in tblJobs can be displayed in a query), but in such a way that each user of the split database can have their own job number selection.