In my form I need to insert, update and view data in one form itself based on same foundset. (I am not using any relations)
To add a new record and update record I am using same set of text field
I am using table view to view data and selects record to edit. The selected records gets populates in record view text fields.
Both record view and table view are in same form within tabless panal
1. How can I refresh foundset for newly added record in foundset and show new record added at the end of table
2. The problem table view is latest values get displayed in tableview but selecting record does not populates in record view
3. For updating values, I facing problem that moment values in record view gets changed is reflected in table view that means value in any text field is change at same moment it gets changed in table view. I don't want that after updating value, user need perform some action (hit save or update button).
plz suggestion...