Solved

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

Posted on 2007-03-23
1
684 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
1 Comment
 
LVL 9

Accepted Solution

by:
tonydemarco earned 500 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

816 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now