Create forms with "drill down" capability

[dngumina]

1.How would I create a form with a grid that will contain cells holding employee names from an Access 97 database? 2.Then what code would I use to double-click a given cell to "drill down" to a form that contains the employees personal info? Each column in the grid would be considered a division and each row in the grid would be considered the employees "grade level".3. From a form how would I display + access an organization chart created in MS Powerpoint? Each column in the grid would be considered a division and each row in the grid would be considered the employees "grade level". Thanks, DG

[JHausmann]

For items 1 and 2 in your post:

1) create a data control that retrieves the data you want to display and the keys you need to get into other tables (employee name, empnumber for example)
2) create a dbgrid (bound) and bind it to the above control
3) hide the columns you don't want the users to see
4) in the double click event for the dbgrid set a global (or class variable) to the value that you will use to retrieve (empnumber) by doing : globalemp = dbgrid.columns(#).value and the load the employee data form (populating it's fields based upon a) another query or b) another control).

Item 3 in your post: don't know.