?
Solved

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

Posted on 2007-03-23
1
Medium Priority
?
714 Views
Last Modified: 2008-03-06
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
Comment
Question by:goingolfn99
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 9

Accepted Solution

by:
tonydemarco earned 2000 total points
ID: 18783656

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question