Steven-
1) What's the design of the three tables?
2) How are the tables related?
3) What is the SQL of any query you're using?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of S and M
Sent: Tuesday, May 24, 2011 9:07 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Referential Integrity and blank rows
Hey everyone,
Somewhere along the way I have boxed myself into a corner. I am not even sure I
know how to explain the problem correctly.
I have two tables that are related by MemberID. I have a form that uses a query
to create entries into each table as appropriate.
HOWEVER, A sub form in another part of the DB only creates a record in one of
the tables.
The right info gets into the right tables as long as I have referential
integrity off.
The problem is that when I edit the info in the form only the entries that have
rows in both columns show. I need to be able to see and edit all the info in
both tables.
SO, I am not sure as to the approach to fix this. Am I using the wrong
query,...maybe I should be using a UNION query?
OR, do I need to force an entry into both tables when the sub form creates an
entry?
No doubt I am not providing enough information so please just let me know what
is needed and I will post it.
Just when I thought I was done!!!
Thanks, Steven
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar