Search results

  1. G

    Looping through query to find highest priority item

    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...
  2. G

    Return results that exactly match criteria

    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...
  3. G

    Database Design and Form Layout/Setup

    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...
Back
Top Bottom