EmployeeID is PK and Auto Increment. The Page Source name is Employee. I have even named it SubContractorEmployees to match the actual table name, still get the error. I have all the fields set on the page linked to a control except CompanyNumber which I set just before saving.
Here is the current Select statement:
select EmployeeID, CompanyNumber, Email, FirstName, LastName, Phone, Photo, HireDate, TerminationDate, DispatchRights, TotalYearsOfService, CCTV, Intrusion, AccessControl from SubContractorEmployees where EmployeeID=:EmployeeID
I have also tried:
select EmployeeID, CompanyNumber, Email, FirstName, LastName, Phone, Photo, HireDate, TerminationDate, DispatchRights, TotalYearsOfService, CCTV, Intrusion, AccessControl from SubContractorEmployees Employee where EmployeeID=:EmployeeID
and
select * from SubContractorEmployees where EmployeeID=:EmployeeID
and
select * from SubContractorEmployees Employee where EmployeeID=:EmployeeID