Add Record Not Working with Admin Group Authority

This topic is locked

Add Record Not Working with Admin Group Authority	10/20/2007 9:24:40 PM
PHPRunner General questions
M MikeB941 author Hello: On an ADD RECORD under PHP Runner 4.1 when you have Admin group authority checked (can see and edit all records for the table or view) for the GroupID of the UserID currently logged in AND security is set to "Users can see and edit only their own data", shouldn't the automatic filling of the OwnerID field with the logged in UserID NOT happen to allow records to be added (i.e. autoincrement) that do NOT belong to the logged in UserID? Running into a problem with this... Thanks for your help with this. Take Care... Mike.


M	MikeB941 author 10/21/2007
	I believe I've found an easy work around - just set the ID for the record to "" (i.e. $values["Record_ID"]=""<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=22440&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' /> in the Before Record Added event for Add Record and make sure you have auto increment set for the table in MYSQL. This seems to override the security setting of the Record ID to whoever is currently signed on and forces an auto increment for the next record upon insertion. I also do NOT have the record ID selected as a field for the add page or the edit page under choose fields. Take Care... Mike.