What causes an "Index is read only" message in Paradox? I have tables as follows Table ClientIssueNames field1: ClientIssueID primary key autoincrement field2: ClientIssueName string 50 Table CIientIssue field1: StaffID long integer foreign key field2: ClientIssueID long integer field3: IssueDate date field4: IssueHours time Table Staff field1: StaffID primary key autoincrement field2: LastName string 50 field3: FirstNames string 50 A master-detail relationship has been created between ClientIssue and Staff on the StaffID field (1:M) A lookup field has been created on ClientIssue as follows: lookup field: IssueLookup keyfields: ClientIssueID lookupdataset: ClientIssueNames lookupkeyfields: ClientIssueID lookupresultfield: ClientIssueName This lookup field is used in a DBGrid displaying data from the ClientIssue table to display a lookup value (string) for the numerical values in the ClientIssueID field. However attempting to change the contents of this field by choosing another value from the drop down list in the grid returns the error "Index is read only". If the master detail link to Staff is removed then the error disappears but obviously I would like to retain the link if at all possible. Using d3 Standard, BDE 4.01 ============================================ Patrick Dunford, Christchurch, NZ http://patrick.dunford.com/ --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
