Search results

Thanks plog! I was able to get it working using your suggestions.

I have a database where part of it consists of an Item table and a Formula table. There is a many-to-many relationship between them so I created a junction table for this purpose. Tables tblItem tblFormula tblFormula_Item_JNT There is a column in tblFormula called [Priority] that is a...

Thanks to both of you for replying. I really appreciate you guys giving your time to help me out. I ended up using billmeye's code with a few modifications, mainly because it was throwing an error when there was no record in tblJob_Procedure_JNT that matched a selected job. The parts I...

I have 3 main tables: tblEmployees, tblJobs, and tblProcedures. (See attachment for relationship diagram and additional supplemental tables) A job can have multiple procedures and an employee can have multiple procedures too. I need to write a query such that when searching by a specific job...

Thanks Spike! After a bit of testing, that seems to have done it. :)

Good point, Spike. I've attached my sample database. Data should be pretty straightforward. I've been using the Employees form to try and get what I need to display. I was also messing with a copy of it too. Please forgive me for any bad naming conventions/design. :(

I have a database with 3 main tables: Employees, Jobs, and Procedures. Criteria: 1. Each employee can have multiple jobs and each job can have multiple employees. 2. Each job can have multiple procedures and each procedure can be in multiple jobs. From this criteria I have a few...