OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need...but my question is what is the syntax to make this happen. Here is what I have so far....
SELECT Door.AcctID, Door.HardwareSetID, Door.ProductID, Door.SillDetail, Door.Comments
FROM Door INNER JOIN Account ON Door.AcctID = Account.AcctID
WHERE ((([Form_Hardware Set - Main]! Software/Hardware used: Access 2007