Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form is read-only, because the Unique Table property is not set.

Status
Not open for further replies.

Dan8376

Technical User
Jan 29, 2002
25
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top