How could I have a lost view of my database and select a certain record then it should go to form view
Are you in List view or table view. This requires list view not table view. Adding a button would be done while a list view layout is in layout mode.
Put a button in the body of the layout. The button can use go to layout to switch to a layout designed for form view. As long as both layouts are based on the same table occurrence, changing layouts is all that you need.
I Must be doing something wrong I have it so that i see my data in a list view format, which i cant seem to put a button on the name of the record to go to form view..
Retrieving data ...