Help using query as record source for form
Posted on 2011-09-04
Using Access 2007, the following query is the record source for a form
SELECT tblSelectionsCountertop.SelectionsMasterID, tblSelectionsCountertop.RoomID, tblSelectionsCountertop.CountertopID, tblCountertop.CountertopName, tblCountertopCat.CountertopCatName
FROM (tblSelectionsCountertop LEFT JOIN tblCountertop ON tblSelectionsCountertop.CountertopID = tblCountertop.CountertopID) LEFT JOIN tblCountertopCat ON tblCountertop.CountertopCatID = tblCountertopCat.CountertopCatID
This works fine, except that my form has a txtbox for Countertop price. This field is located in tblDevelopmentCountertop which has the following fields:
Every time I try to modify the query to include this table, or a subquery based on this table, I lose the ability to add new records.
Can anyone enlighten me as to how to include tblDevelopmentCountertop.CountertopPrice in the query and retain the ability to add records?
BTW, I have a public function defined to retrieve the DevelopmentID, GetvDevelopmentID()