I would like to know how can I display, add, delete, edit the records in unbound DBGrid.
The fields for the DBGrid are Tree No, Species Code, Type, Diameter(cm), Height(m) and Volume(m3).
tree no, species code, diameter, height and volume are in table called ASM while type is in table called SPECY in access.
after the users get to this form, the system needs to display the records in DBGrid before allow the users to add, edit, delete.
to display the records, the system needs to find in ASM table for "PECREFNO", "BLOCK NO", "BLOCK AREA", "STRIP NO", "STRIP AREA".
If under the "PECREFNO", "BLOCK NO", "BLOCK AREA", "STRIP NO", "STRIP AREA", got records for Tree No, Species Code, Type, Diameter(cm), Height(m) and Volum(m3). Then, display it and allow the users to edit or delete. if not, allow the users to add.
besides, is that possible for me to do renumbering (for tree no) and set the function like combo box (for species code) in DBGrid.