i created a database then i switched to table view and have set so that only name fields appear in table view , i want to know how to go to the related record in form view when i click on a name in table view

You cannot put buttons on fields or record rows in table view. Use list view.

You can use an OnobjectEnter script trigger; see attached.

Names.fp7.zip