|
| |
|
|
ScribeVision
Posts: 274
From: None
Status: offline
 |
"DB Col ID Must Be Mapped to Input Field" Error? - 2/24/2005 1:22:40
Hi,
Lately, anytime I make a change to a form used to insert records into a table and go to the 'save fields' tab, I get an error message "The Database column 'ID' must be mapped to an input field in order for the update to be successful. Modify one of the fields to map to ID".
The ID field in the table is an autonumber so I've never had to map to that field. The only way to get around this is for me to open the database, delete the ID field in that table, do the form update, and then go back an add the ID autonumber field back.
Obviously, this is a pain because it means shutting down the site everytime I need to do this.
Any idea why this error occurs?
|
|
|
|
ScribeVision
Posts: 274
From: None
Status: offline
|
RE: "DB Col ID Must Be Mapped to Input Field"... - 5/19/2005 3:54:33
I'm still having this problem and it is certainly annoying.
I can't believe that no one else has encountered this error before.
Could it be related to the fact that I am now on a machine using Office 2003?
| |
|
|
|
ScribeVision
Posts: 274
From: None
Status: offline
|
RE: "DB Col ID Must Be Mapped to Input Field"... - 5/19/2005 8:57:35
Basically, I get this error whenever I have to add, remove or modify the field mapping on a form.
Some of these are forms I've used for years, but had to go back and at a new field. After I map the new field anc click ok, I get the message.
If I cancel, open up the table and delete the ID field, go back to the form and do the mapping it works. Then I have to back to the table and re-add the ID autonumber field.
| |
|
|
|
patricksims
Posts: 37
Joined: 7/7/2005
Status: offline
|
RE: "DB Col ID Must Be Mapped to Input Field"... - 9/8/2005 18:15:21
I suddenly started getting this error as well. The only change I made was adding two checkboxes to my form, and adding two text format database columns to map them two. The column that it is saying needs to be mapped is a yes/no column that didn't have anything mapped to it before and and has a default value of 'yes'.
| |
|
|
|
gfritsch
Posts: 3
Joined: 10/15/2003
Status: offline
|
RE: "DB Col ID Must Be Mapped to Input Field"... - 10/16/2005 15:32:55
I am getting this error also. It seems to occur when the form (has less fields than the Access database. Is there a way to get around this? In most of my forms, I only want to update 4 or 5 fields in a database, then when the "next" button is pressed, the rest of the information is processed on another form. The database has about 30 fields in total.
thanks
_____________________________
| |
|
|
|
ScribeVision
Posts: 274
From: None
Status: offline
|
RE: "DB Col ID Must Be Mapped to Input Field"... - 10/17/2005 1:31:40
I still have not found the root cause or optimal fix for this problem. I've gotten used to my workaround which is to:
- open by local test database and delete the ID field
- make my modifications to the form in FP
- re-add the ID field to the table in the DB
- drive on
This problem occurred when we upgraded from Server 2000 to 2003.
| |
|
|
|
patricksims
Posts: 37
Joined: 7/7/2005
Status: offline
|
RE: "DB Col ID Must Be Mapped to Input Field"... - 10/17/2005 12:40:43
My solution was to change the field type from yes/no to text, publish, then change back.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 