AnsweredAssumed Answered

Errors when trying to edit data over the web -

Question asked by Sharpie251 on Jul 29, 2010
Latest reply on Jul 30, 2010 by philmodjunk


Errors when trying to edit data over the web -

Your post

Hi there,

I am trying to have our be database acceable over the web. I have it hosting on our server fine and I data is viewable and searchable. However, I keep gettig errors when trying to Edit the records. I keep getting:

"Error: 506 - Value in field is not listed on the value list specified in validation entry option" or
"201 Field cannot be modified" and I am sure there are a few more I will come accross.

I believe I set all access privliges correct. The only thing I can think of is wen the PHP Assistant aked me to pick a layout, the layout I choose only showed one table and none of the other related tables.

I would use the IWP but viewing the data in a table form is hard to read on some monitors and not the best user interface.

I hope someone can help me. The database is located at: (this is all fake data right now)

I created a Help user and a password helper.

If anyone can help me that would be greatly appreciated.

Thank you