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