Just execute the Read method on the SmartObject with a Rule when the button is clicked, map the output of the Read Method to controls on the form.

Thanks it worked ,but I still have an issue I have employee code as a picker list from the database when I choose a specific code number the rest fields (employee name-Business unit) are displayed with other  employee data ,for example employee code:1515 must display employee name:john,business unit:finance but instead of this it displays another  employee name and business unit I want when I choose specific employee code only its related employee name and business unit to be displayed

Typically you will set the Identifier of the Picker control to be the Primary Key column of your source table, e.g. EmployeeID.

Then have an onchange rule for the picker which first check if it is empty and then do the SmartObject Read method passing in the value of the Picker Control.

It worked ,thanks for your help

Sorry there is one last thing,I created the form where I pick up the employee code and his business unit and name displayed automatically from the smartobject I also  filled another fields in the same form like date,amount and I want when I fill these fields to be added to the smartobject not in a new record I want it to be added in the same record of the employee code I picked,how can I do this

@Deon could you perhaps assist with the last question as well? Thanks!

The last question has been solved, thanks for your consideration and help