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

C

Chris

I have a DB set up for recording enquiries and clients. All clients start
off as enquiries and are converted to clients by checkbox value.



When an enquirer decides to become a client all of that persons details are
recorded i.e. mortgage details, children, employment etc.



To input the clients details, the clients name is selected from a dropdown
box based on a query that selects all Clients (Not enquiries)



The problem is that some Clients have a joint mortgage. In this case all
the same details from a client would have to be recorded for the partner.



I have tried to set up a partners table and a Joint table



TblClients

ClientID - autonum - PK

Fname -text

Sname - text

Enquiry - y/n

Client - y/n

Joint - Y/n



TblPartner

PartnerID - AutoNum

Fname - text

Sname - text



TblJoint

JointID - AutoNum - PK

ClientID - AutoNum - FK

PartnerID - AutoNum - FK



I would like to have the forms set up using the tab control. When the
checkbox for joint is selected I would like the tabs for the partners
details to be visible ,



At the moment I have a single form based on a query linking the 3 tables
together. When I enter both Client details and the partners details the
form works. However, when I enter either the client or the partner details
and come back to the record I cannot enter any details and I get the message



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



Please tell me what I'm doing wrong.
 
S

StCyrM

Hi Chris

Just as a test, open your query and see if you can add a record. I suspect
that that's where your problem is.

Best regards

Maurice St-Cyr

Micro Systems Consultants, Inc.
 
C

Chris

The query acts the same way as the forms. I can enter a new record for the
two people. However, when I miss out either the client or partner I can't
update them at a later time. Is this a problem with my query.
 
C

Chris

p.s. this is the query

SELECT Joint.JoinID, tblClients.ClientID, tblClients.FName,
tblClients.SName, tblClients2.JClientID, tblClients2.PFName,
tblClients2.PSName
FROM tblClients INNER JOIN (tblClients2 INNER JOIN Joint ON
tblClients2.JClientID = Joint.JClientID) ON tblClients.ClientID =
Joint.ClientID;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top