Hi, i'm trying to learn some ODBC database programming and i'm using MS Access with MFC. As an exersice i started to create this database app which should contain information about some music bands. Inside Access, i have 2 tables: artistinfo and albums. 'artistinfo' should contain band names, genre and stuff like that. 'albums' should contain lists of albums for each band. That is, each field holds album names of one of the bands. Then in the MFC app, i have a combobox to load those albums names. When i hit the 'next' button in the app and go to a next record, correct album names should load into the combobox. Now my problem is that when adding more bands into the db at runtime, i must somehow append new fields to the albums table, and i'm not sure if this is possible. Is it possible? or is there another way altogether for doing this? i tried adding 'lookup columns' to the table at design time, but i cannot figure out how to use thoes lookup values from the MFC app. Any help please.
Thanks a lot.