Remember favourites...

[neillovell]

Hi,
I'm trying to get started on this immediate problem but I'm unsure of how to implement my solution.
In my timesheet application I have a table containing a list of projects. Users currently use a drop down menu to select a project and then record their time alongside it.

Of course to make things difficult the projects list will be anything from 100 projects to 800 projects. Too many for a user to scroll through every day to add their time record against.

SO I want to have maybe a checkbox that the user can use to mark a project as a "favourite" so the drop down menu displays their favourites first (to save time wading through).

Now I figure a table and a query on that could do the job, but what fields does the table need? Or can I add favourite projects to my current table of employees (which holds their pay details etc.), in which case how would I send the data from this checkbox to that table.

As you can see, I need a foothold!

 

[DerekAOE]

Since the relationship between Employee and Project will be Many-To-Many (Employees can have many projects as favourite, and Projects can be the favourite of many Employees). The table should have an EmployeeID field and a ProjectID field, with an arbitrary key field (say, an autonumber).
When finding an employee's favourites, set up a link between the employee table and the intermediate table to get the projects that are the favourite of the employee. Project details can then be returned by linking the intermediate table to the project table via ProjectID.
You will need to do a bit of coding to allow the user to select/deselect projects from their favourites. The code will need to add/delete entries from the intermediate table as the boxes are ticked/cleared i.e. when the user clicks OK.

 

[neillovell]

By link do you mean a join?

 

[neillovell]

Has anyone implemented this kind of set up before and can talk me through it? I'm still having difficulty.

 

[neillovell]

Got it sorted, thanks!