Errors when trying to edit data over the web -
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: http://newco.ath.cx:81/newcodata/home.php (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.