Hi there!
I am making a database and I want to add columns to an existing table (tbl1) using the records from another table (tbl2) with VBA.
For example: the first added column (tbl1) should be named by the first record from the first column (tbl2) and should also have the default value from the first record from the second column (tbl2); second column (tbl1) using the second record (tbl2), and so on. I hope that makes sense.
Can anyone help me? Thank you.
I am making a database and I want to add columns to an existing table (tbl1) using the records from another table (tbl2) with VBA.
For example: the first added column (tbl1) should be named by the first record from the first column (tbl2) and should also have the default value from the first record from the second column (tbl2); second column (tbl1) using the second record (tbl2), and so on. I hope that makes sense.
Can anyone help me? Thank you.