2. PHPRunner General questions
  3. Inserting master record id when adding child record
This topic is locked

Inserting master record id when adding child record

 		4/7/2014 7:26:30 PM
PHPRunner General questions
jwoker author

I thought phprunner used to do this automatically but now I'm not sure. Using 7.1. I have Users set as the master table and Events set as the detail table. Users.ID is matched to Events.UserID
When I Add a new Event my users.id is not automatically put into the new record. How do I set that up on the Events Add Page?
jwoker author 4/7/2014

Ok, I added Events.UserID as a search field and now it is auto inserting into the Added record.
jwoker author 4/8/2014

This issue is back. How do I make sure the master User.id is added during the Add page process of the child record so that Child.UserID = User.ID?
Sergey Kornilov admin 4/9/2014

You can use Advanced Security mode 'Users can see and edit their own data only' for the child table linking Child.UserID with User.ID.