Editing a Form with a Cascading ComboBox

[MercyKiller101]

Hey guys, newbie here.



I'm having a problem with Access, maybe you can help out. I work in a very small IT support company, and we need a system for our technicians to be able to log their work, so it can then be priced and processed for billing. Ideally this entire process is done using one database split into multiple front ends.

Some relevant information:
I have 4 Tables: Clients(*Client ID),Projects(*Project ID), Client Projects(*ClientProject ID),Job Logs(*JobLogID)
Client and Projects have a many is to many relationship, hence why I have Client Projects
Job Logs does not have fields for Project ID or Client ID, it has a many is to one relationship with ClientProject ID(1 ClientProject ID per Job Log)


The area I'm having trouble is in Editing Job Logs Form. I have a cascading combobox and every time I edit a job log the entire cascading combobox is empty. Other information entered when you add the job log is loaded properly. The cascading Combobox consists of Clients, which then filters out Projects. When you select a Project, it saves the ClientProject ID. This means that the Clients combobox has no bound value. I tried setting the Control Source to a query based on Client Projects so that it could display only the Client Name in the combobox, unfortunately this completely broke the filter for the cascading combobox.

If anyone can at least point me in the right direction I'd really appreciate it. Thanks in advance!

[June7]

Want to provide the db for analysis? Follow instructions at bottom of my post.

[MercyKiller101]

Hey, thanks for the quick reply.

Database.zip

The problem I described is in the Edit Job Logs Form.