I am working with a SQL Server database and I have an an Acess 2000 front-end ADP, on an XP Prof computer. I'm having a problem trying to edit records in one of my forms that is based on the following stored procedue:
ALTER Procedure qryCustCompany1 (@CustCode nvarchar(10)) As
SELECT tblCompany.CompanyID AS CompID, tblCompany.FEIN, tblCompany.StateTaxNo, tblCompany.CompanyName, tblCompany.CompanyType, tblCompany.CompanyClass, tblCompany.AddressID AS CompanyAddress, tblCompany.CustomerType, tblCompany.ParentCompany, tblCompany.MNAMember, tblCustomer.CustCode, tblCustomer.CustomerName, tblCustomer.AddressID AS CustomerAddress, tblCustomer.CompanyID
FROM tblCompany INNER JOIN tblCustomer ON (tblCompany.CompanyID = tblCustomer.CompanyID and tblCustomer.CustCode = @CustCode );
return
When I try to edit any of the fields from the tblCompany table I get the following message: "Form is read-only, because the Unique Table property is not set". I tried to set the Unique Table property to: tblCompany, but I got the following error: "The text you entered isn't an item in the list. Select an item from the list, or enter text that matches one of the listed items." When I click on the drop down arrow for the unique table property, there is nothing in the list to select.
Any suggestions?
Thanks
Daniel
ALTER Procedure qryCustCompany1 (@CustCode nvarchar(10)) As
SELECT tblCompany.CompanyID AS CompID, tblCompany.FEIN, tblCompany.StateTaxNo, tblCompany.CompanyName, tblCompany.CompanyType, tblCompany.CompanyClass, tblCompany.AddressID AS CompanyAddress, tblCompany.CustomerType, tblCompany.ParentCompany, tblCompany.MNAMember, tblCustomer.CustCode, tblCustomer.CustomerName, tblCustomer.AddressID AS CustomerAddress, tblCustomer.CompanyID
FROM tblCompany INNER JOIN tblCustomer ON (tblCompany.CompanyID = tblCustomer.CompanyID and tblCustomer.CustCode = @CustCode );
return
When I try to edit any of the fields from the tblCompany table I get the following message: "Form is read-only, because the Unique Table property is not set". I tried to set the Unique Table property to: tblCompany, but I got the following error: "The text you entered isn't an item in the list. Select an item from the list, or enter text that matches one of the listed items." When I click on the drop down arrow for the unique table property, there is nothing in the list to select.
Any suggestions?
Thanks
Daniel