About insertion and retieval of data in Datawindow : iam new to powerbuilder ,iam learning basic pb rightnow..
im not yet good at coding i need a help from anyone regarding a module iam doing right now. I have created an employee master table, and created two datawindows one is tabular and freeform for this table ,now i have allocated these datawindows in a single window one is front and other is back .my requirement is i want to insert the row in freeform view and reflect them  back in tabular,during insertion it should check all scenarios like whether an empty row is there or not, if yes then it should set the focus to that empty row instead of inserting an empty row again.when  double clicked on particular row in  tabular  it should retrieve that record  in freeform view while hiding tabular datawindow. when  i right click and select tabular view when iam in freeform view it should show me tabular view and vice versa..i need coding for all these can anyone help me out with this please thanks in advance !!