This topic is locked
[SOLVED]

 Using Access Query

5/15/2003 5:11:01 PM
ASPRunnerPro General questions
author

I built two tables each two fields, built a one to many relationship based on a number (text) in each table.
Table One: Person

wname

wnumber
Table Two: Flavor

custID

flavor
I set up the relationship one to many.
I then built an Access Query (PFQuery) with the two tables and three fields

wname

wnumber

flavor
I ran ASP Runner against that PFQuery. I added flavors for all records in Access.
I opened the web. All fields dislpay. I can edit all fields.
However when I "add new" I cannot save the new record.
I get
ASP error happened
Technical information

Error number -2147217900

Error description [Microsoft][ODBC Microsoft Access Driver] Cannot update 'Flavor'; field not updateable.

URL /two/PFQuery_edit.asp

SQL query insert into [PFQuery] (WName, WNumber, Flavor) values ('Grovler', '98', 'Ice'
What do I do?
Walt

500035 5/15/2003

Above, the relationship was between the two number fields (text)
Walt

admin 5/28/2003

Walt,
make sure that Flavor field is not autonumber. Autonumber fields cannot be updated.
Sergey Kornilov