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
Selasa, 24 Mei 2011
[MS_AccessPros] Referential Integrity and blank rows
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar