In the database I have been working on, I am trying to redo a query a friend did for me. However since he had done it, I have completely restructured the tables and now no longer know to get it to do what I am after.
I am hoping to get some insight so I can better understand this (and not have to ask a question like this again).
I have 4 tables involved in this (don't know if they're all relevant). The tables are tblJobDetails, tblDrawings, tblDrawingfixtureType and tblFixtureType. I am trying to make a query datasheet to input types into table tblFixtureTypes, but keep them "under" a certain job (trying to use JobID in tblJobDetails). The problem I have run into is JobID is present in tblDrawings, but no further down that chain.
The couple queries I have done either show every type in the DB, or nothing. I am not able to get it to show just the types for that given job. Am I trying to tie it to the wrong thing? The initial criteria I tried was [Form]![JobQuote]![JobID], but it doesn't work. The query doesn't return anything with that in it.
What am I doing wrong on this one? I think I am not understanding how to properly use WHERE in SQL.
I can attach the DB if required.
I am hoping to get some insight so I can better understand this (and not have to ask a question like this again).
I have 4 tables involved in this (don't know if they're all relevant). The tables are tblJobDetails, tblDrawings, tblDrawingfixtureType and tblFixtureType. I am trying to make a query datasheet to input types into table tblFixtureTypes, but keep them "under" a certain job (trying to use JobID in tblJobDetails). The problem I have run into is JobID is present in tblDrawings, but no further down that chain.
The couple queries I have done either show every type in the DB, or nothing. I am not able to get it to show just the types for that given job. Am I trying to tie it to the wrong thing? The initial criteria I tried was [Form]![JobQuote]![JobID], but it doesn't work. The query doesn't return anything with that in it.
What am I doing wrong on this one? I think I am not understanding how to properly use WHERE in SQL.
I can attach the DB if required.
Attachments
Last edited: