How to create an external table for hbase?

I want such facility in my database that can create field auto. in a table based on other table's field value.

• I have a database for membership management, in that I have to track attendances for meetings, now I have table called 'Members' with members details and other named 'Attendance' which have members names as fields , now I want some thing that can create a new field in 'Attendance' table as I save new member in 'Member' table. Can anyone guide me..?

• Answer:

  David, I'm not sure why you would want to create a new field in a table during data entry, but I can guide you on how to do it. You will not be able to add a field to a table while the table is open or while any recordsets are open on the table (by you or any other simultaneous user), so you should not attempt this in a multi-user environment. Here is the code to add a field, using DAO objects: ************************** Public Sub AddField() Dim db As Database Dim tbl As TableDef Dim fld As Field Dim txtNewField As String Dim txtTableName As String txtNewField = "MyNewField2" 'substitute your field name here txtTableName = "tblTest" 'substitute your table name here Set db = CurrentDb() Set tbl = db.TableDefs(txtTableName) Set fld = tbl.CreateField(txtNewField, dbText, 15) tbl.Fields.Append fld Set db = Nothing Set fld = Nothing Set tbl = Nothing End Sub *************************** You will have to evaluate the name of the new field each time, so you do not get errors trying to create a duplicate field name. You need to check the type and size of the new field in the CreateField command above to suit yourself. If you meant, instead, that you wish to add a new record to another table, then that is another matter. If so, and you are still interested, I might have time to reconsider your question.