L
Larry Kahm
I have three tables:
tblContacts, which contains ContactID (PK), FirstName, LastName, and
assorted other information
tblContactModes, which contains ContactModeID (PK), ContactID (FK),
PhoneNumber, and additional information
tblReferences, which contains ReferenceID (PK), RefNameID (FK), RefStatus,
and more
When I build the following query, it is not updateable.
SELECT tblReferences.ReferenceID, tblReferences.RefStatus,
tblContacts.FirstName, tblContacts.LastName, tblContactModes.PhoneNumber
FROM (tblContacts INNER JOIN tblReferences ON tblContacts.ContactID =
tblReferences.RefNameID) INNER JOIN tblContactModes ON tblContacts.ContactID
= tblContactModes.ContactID;
If I remove the PhoneNumber requirement (and the tblContactModes),
everything is fine.
But I am stumped as to how to show that a person is a reference and what
their phone number is. Any and all help is greatly appreciated.
Thanks!
Larry
tblContacts, which contains ContactID (PK), FirstName, LastName, and
assorted other information
tblContactModes, which contains ContactModeID (PK), ContactID (FK),
PhoneNumber, and additional information
tblReferences, which contains ReferenceID (PK), RefNameID (FK), RefStatus,
and more
When I build the following query, it is not updateable.
SELECT tblReferences.ReferenceID, tblReferences.RefStatus,
tblContacts.FirstName, tblContacts.LastName, tblContactModes.PhoneNumber
FROM (tblContacts INNER JOIN tblReferences ON tblContacts.ContactID =
tblReferences.RefNameID) INNER JOIN tblContactModes ON tblContacts.ContactID
= tblContactModes.ContactID;
If I remove the PhoneNumber requirement (and the tblContactModes),
everything is fine.
But I am stumped as to how to show that a person is a reference and what
their phone number is. Any and all help is greatly appreciated.
Thanks!
Larry