Selasa, 24 Mei 2011

[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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar