If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
recordset problem
I tried to run a select query based on two tables and they are linked by two
fields. After I open up the datasheet as of the result of the query, I tried to change the value in one of the field and it said "recordset is not updatable". Can anyone please help? Thanks. |
#2
|
|||
|
|||
"00allen_iverson" wrote in message
... I tried to run a select query based on two tables and they are linked by two fields. After I open up the datasheet as of the result of the query, I tried to change the value in one of the field and it said "recordset is not updatable". Can anyone please help? Thanks. You need to have the appropriate indexes on the table. In a typical scenario, you might have two tables: tblOrder: OrdID, OrdNumber, OrdDate, etc tblOrderItem: ItmID, ItmOrdID, ItmProduct, ItmQuantity, etc So you can have many line items on one order. Both tables have primary keys (OrdID and ItmID) and the field ItmOrdID is indexed with duplicates allowed. As an extra (and advisable) step, you can enforce referential integrity between the two fields. When you create a query, you will find that the join is added automatically and the query is updateable. |
#3
|
|||
|
|||
If the field you are trying to change is used in the link, then it will be
read only as changing the relationship would invalidate the row. If the field is NOT part of the relationship (or PK/FK constraints) it will be updatable. "00allen_iverson" wrote in message ... I tried to run a select query based on two tables and they are linked by two fields. After I open up the datasheet as of the result of the query, I tried to change the value in one of the field and it said "recordset is not updatable". Can anyone please help? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem Retrieving Printer Object Information | Beverly R | Setting Up & Running Reports | 2 | May 16th, 2005 06:02 PM |
Row Autofit problem Excel 2003 | Matthias Klaey | General Discussion | 0 | January 19th, 2005 05:33 PM |
Office XP Update Problem | Bill | General Discussions | 0 | December 1st, 2004 06:11 PM |
Problem with display of header in Word 2003 | Padser | Page Layout | 0 | October 8th, 2004 07:47 AM |
Big Problem. We need the fix | Captain K | Calendar | 0 | July 8th, 2004 04:50 PM |