Added table to database, added to form, now cannot update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All worked fine until we added this table to form. Now cannot even delete
table and get form to work correctly.

Here is SQL statement from form's record source:

SELECT tblSalary.*, tblEmployee.*, tblSalary.PayRatioMemo,
qselFullName.[Full Name], qselFullName.SocialSecurity, tblSalary.[Benefit
Notation], tblHRInsurance.InsurancePercent, tblHRInsurance.InsDesc
FROM tblTimeOff INNER JOIN (((tblEmployee INNER JOIN qselFullName ON
tblEmployee.SocialSecurity = qselFullName.SocialSecurity) INNER JOIN
tblHRInsurance ON tblEmployee.SocialSecurity = tblHRInsurance.EmployeeId)
INNER JOIN tblSalary ON tblEmployee.SocialSecurity = tblSalary.EmployeeID) ON
tblTimeOff.TimeOffID = tblSalary.TimeOffID;

Let me know if more information is needed.
 
Back
Top