Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 723
  • Last Modified:

Cannot enter value into blank field on 'one' side of outer join

This may seem pretty easy but i'm bashing my head in right now. I'm cleaning up my database and it seemed to work in my previous version but I'm not able to add any data into my query. because of the statement "Cannot enter value into blank field on 'one' side of outer join" Can someone give me a quick fix and take a look at my sql query. I'm pretty sure its the way my tables are joined but I can't seem to figure out why it worked before. Thanks


SELECT PRODUCT_STOCKING_LOC_TIE.PRODUCT_BARCODE, PRODUCT_STOCKING_LOC_TIE.DESCRIPTION, PRODUCT_STOCKING_LOC_TIE.STOCKING_UOM AS UOM, PRODUCT_STOCKING_LOC_TIE.STOCKING_LOCATION_NAME AS LOCATION, tblMainDetail.QTY
FROM PRODUCT_MASTER RIGHT JOIN (PRODUCT_STOCKING_LOC_TIE LEFT JOIN tblMainDetail ON PRODUCT_STOCKING_LOC_TIE.ID = tblMainDetail.ID) ON PRODUCT_MASTER.PRODUCT_BARCODE = PRODUCT_STOCKING_LOC_TIE.PRODUCT_BARCODE
WHERE (((PRODUCT_STOCKING_LOC_TIE.STOCKING_LOCATION_NAME)=[Forms]![frmMain]![STOCKING_LOCATION]));
0
goingolfn99
Asked:
goingolfn99
1 Solution
 
tonydemarcoCommented:

If the "many" side join field doesn't appear in the datasheet
Add the join field from the "many" side to your query to allow adding new records.

HTH
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now