T
tvh
I can't edit records in a query when I add a third table....? Two tables
work fine together in the query, but when I add the third table, I'm unable
to edit records in the query and the associated form. Why? Here's the SQL
statement if it helps. Thanks in advance!
SELECT tblClientInformation.tblU2ClientID,
tblClientInformation.citblCompanyName, tblClientInformation.citblContactName,
tblClientInformation.citblContactTitle, tblClientInformation.citblAddress,
tblClientInformation.citblCity, tblClientInformation.citblState,
tblClientInformation.citblZipCode, tblClientInformation.citblWorkPhone,
tblClientInformation.citblExt, tblClientInformation.citblCellPhone,
tblClientInformation.citblFaxNumber, tblClientInformation.citblEmail,
tblWorkOrders.[wotblWorkOrder#], tblWorkOrders.wotblCompanyName,
tblWorkOrders.wotblDate, tblWorkOrders.wotblTime, tblWorkOrders.[wotblJob#],
tblWorkOrders.[wotblPO#], tblWorkOrders.wotblJobDescription,
tblWorkOrders.wotblLocation, tblWorkOrders.wotblServicesRequested,
tblWorkOrders.wotblAdditionalInformation,
tblWorkOrders.wotblInitiallyAssignedTo
FROM (tblClientInformation INNER JOIN tblWorkOrders ON
tblClientInformation.tblU2ClientID = tblWorkOrders.wotblCompanyName) INNER
JOIN tblClientSiteContacts ON tblClientInformation.citblContactName =
tblClientSiteContacts.tblSiteContactName
ORDER BY tblWorkOrders.[wotblWorkOrder#];
work fine together in the query, but when I add the third table, I'm unable
to edit records in the query and the associated form. Why? Here's the SQL
statement if it helps. Thanks in advance!
SELECT tblClientInformation.tblU2ClientID,
tblClientInformation.citblCompanyName, tblClientInformation.citblContactName,
tblClientInformation.citblContactTitle, tblClientInformation.citblAddress,
tblClientInformation.citblCity, tblClientInformation.citblState,
tblClientInformation.citblZipCode, tblClientInformation.citblWorkPhone,
tblClientInformation.citblExt, tblClientInformation.citblCellPhone,
tblClientInformation.citblFaxNumber, tblClientInformation.citblEmail,
tblWorkOrders.[wotblWorkOrder#], tblWorkOrders.wotblCompanyName,
tblWorkOrders.wotblDate, tblWorkOrders.wotblTime, tblWorkOrders.[wotblJob#],
tblWorkOrders.[wotblPO#], tblWorkOrders.wotblJobDescription,
tblWorkOrders.wotblLocation, tblWorkOrders.wotblServicesRequested,
tblWorkOrders.wotblAdditionalInformation,
tblWorkOrders.wotblInitiallyAssignedTo
FROM (tblClientInformation INNER JOIN tblWorkOrders ON
tblClientInformation.tblU2ClientID = tblWorkOrders.wotblCompanyName) INNER
JOIN tblClientSiteContacts ON tblClientInformation.citblContactName =
tblClientSiteContacts.tblSiteContactName
ORDER BY tblWorkOrders.[wotblWorkOrder#];