F
Frank
My problems began because I used the look-up feature in my principle table of
my database. I am trying to rectify this problem and I have run into a snag.
I am using one table (tblPersonnel) to populate 5 different fields in my
query. When I open the datasheet view the fields are not populated with any
data from tblPersonnel. I have included the SQL view to help shed light on
the problem.
SELECT tblIncoming.dtmDateReceived, tblCompanies.chrCompanyName,
tblIncoming.[chrDocRef#], tblIncoming.memSubject,
tblPersonnel.chrStaffReferenceIndicator AS PrimaryAction,
tblPersonnel.chrStaffReferenceIndicator AS [SupportAction(1)],
tblPersonnel.chrStaffReferenceIndicator AS [SupportAction(2)],
tblPersonnel.chrStaffReferenceIndicator AS [SupportAction(3)],
tblPersonnel.chrStaffReferenceIndicator AS [SupportAction(4)],
tblIncoming.chrFollowUp, tblOutgoing.chrSTATUS, tblIncoming.memComments
FROM ((tblIncoming LEFT JOIN tblCompanies ON tblIncoming.chrCompany =
tblCompanies.idsID) LEFT JOIN tblPersonnel ON (tblIncoming.chrPrimaryAction =
tblPersonnel.idsID) AND (tblIncoming.[chrSupportAction(1)] =
tblPersonnel.idsID) AND (tblIncoming.[chrSupportAction(2)] =
tblPersonnel.idsID) AND (tblIncoming.[chrSupportAction(3)] =
tblPersonnel.idsID) AND (tblIncoming.[chrSupportAction(4)] =
tblPersonnel.idsID)) LEFT JOIN tblOutgoing ON tblIncoming.[chrDocRef#] =
tblOutgoing.[chrResponcetoDocRef#]
WHERE (((tblOutgoing.chrSTATUS) Is Null));
my database. I am trying to rectify this problem and I have run into a snag.
I am using one table (tblPersonnel) to populate 5 different fields in my
query. When I open the datasheet view the fields are not populated with any
data from tblPersonnel. I have included the SQL view to help shed light on
the problem.
SELECT tblIncoming.dtmDateReceived, tblCompanies.chrCompanyName,
tblIncoming.[chrDocRef#], tblIncoming.memSubject,
tblPersonnel.chrStaffReferenceIndicator AS PrimaryAction,
tblPersonnel.chrStaffReferenceIndicator AS [SupportAction(1)],
tblPersonnel.chrStaffReferenceIndicator AS [SupportAction(2)],
tblPersonnel.chrStaffReferenceIndicator AS [SupportAction(3)],
tblPersonnel.chrStaffReferenceIndicator AS [SupportAction(4)],
tblIncoming.chrFollowUp, tblOutgoing.chrSTATUS, tblIncoming.memComments
FROM ((tblIncoming LEFT JOIN tblCompanies ON tblIncoming.chrCompany =
tblCompanies.idsID) LEFT JOIN tblPersonnel ON (tblIncoming.chrPrimaryAction =
tblPersonnel.idsID) AND (tblIncoming.[chrSupportAction(1)] =
tblPersonnel.idsID) AND (tblIncoming.[chrSupportAction(2)] =
tblPersonnel.idsID) AND (tblIncoming.[chrSupportAction(3)] =
tblPersonnel.idsID) AND (tblIncoming.[chrSupportAction(4)] =
tblPersonnel.idsID)) LEFT JOIN tblOutgoing ON tblIncoming.[chrDocRef#] =
tblOutgoing.[chrResponcetoDocRef#]
WHERE (((tblOutgoing.chrSTATUS) Is Null));